I'm on 2010 and there's no issue. You wouldn't expect any change in A1 or A2 with an addition to A6, it's outside your range. When you say "review the formulas" in A1 and A2, exactly what are you doing? Entering into the formula bar or just clicking on the cell to look at them. Is your calculation mode set to manual instead of automatic?
Bookmarks