Excel Formual No Longer Adding Column Numbers

[smittywes38]

Hello Folks,

I have several pages (tabs) associated with my spreadsheet. Each page displays numerical data. A very simple "Sum" formula is adding the numbers at the bottom of the column. All my cells that are totalling my numbers have stopped adding.
What has happened? Any ideas?

Thanks,

Smitty

 

[xlhelp]

I believe your calculation has turned to Manual. You may want to change it to automatic.

A test to see if it is set to manual is to press F9 on your keyboard. Calculation should take place. Else some other thing is gone wrong.

The command to turn to auto is under options. (Were it is depends on whether you are 2007 or not)

I don't particularly care about apathy