View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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..