Formulae in spreadsheet no longer update with new data

S

Stevej47

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..
 
R

Ron Coderre

It seems like the calculation is set to Manual:

Try this:
Tools>Options>Calculation tab
Check: Automatic calculation

Does that help?

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

XL2002, WinXP-Pro
 
Top