Formulae in spreadsheet no longer update with new data
 

I have a simple accounting spreadsheet that I've used for months. All of a
sudden, the formulas do not work when I add new data. Spreadsheet still
displays the old sums and differences. What has happened that corrupted
these spreadsheets. If I start all over again, the new spreadsheet apperas
to work fine..

Formulae in spreadsheet no longer update with new data
 

It seems like the calculation is set to Manual:

Try this:
ToolsOptionsCalculation tab
Check: Automatic calculation

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Stevej47" wrote:

I have a simple accounting spreadsheet that I've used for months. All of a
sudden, the formulas do not work when I add new data. Spreadsheet still
displays the old sums and differences. What has happened that corrupted
these spreadsheets. If I start all over again, the new spreadsheet apperas
to work fine..