Auto Sum Problem

[tsmalz]

I have a simple spreadsheet with 4 different columns with numbers that I need to change frequently. When I change these numbers the totals at the bottom - at apprx line 95 - does not change. I have tried everything. I have to do it manually. Gets old. What am I doing wrong? Very simple use of Excel but I cant seem to find what the problem is. Never happened before. Help!

Thx

 

[ADAMC]

Hi welcome to the board!

Can you post the formulas you are using with some more details on what happens on your worksheet so we can try to figure out why line 95 doesnt change?

 

[Gates Is Antichrist]

A couple of possibilities:
Check tools/options/calculation and set it to automatic.

Failing that, in the unfortunate possibility that you have a "corrupt workbook" go edit/move and go to a new workbook, and see if it works then.

Finally, do you know if there is any VBA code in action here?