Is there a way to calculate an entire worksheet which has autosum totals in several places thru out the sheet. I tried to highlight the whole sheet and then press F9, but it doesn't seem to work. Suggestions?
The autosums didn't update for some reason. Up until now I had been going in and calculating each autosum total individually, but what I am doing now has 7 identically formatted worksheets and it was becoming tedious. The F9 or Shift F9 doesn't work, I don't know if I'm doing something wrong. I highlight the sheet in the top left and nothing changes or updates when I press either.