Sheet has stopped calculating...
 

A spreadsheet that I wrote a few months back has (for some reason) stopped
calculating totals. It's a declining balance spreadsheet used for my business
purchases. There are simple formulas to calculate column totals and then
others to do simple subtraction for the declining balance. Did I turn
something off by mistake that made this sheet do this? It worked fine when I
tested it and for about 6 months afterward and then suddenly stopped. Now, if
I go back to a previous entry and delete it and/or change it, nothing happens
to the totals that have already been calculated. I'm stumped.

ToolsOptions, Calculation tab, check Automatic

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"mailrail" wrote in message
...
A spreadsheet that I wrote a few months back has (for some reason) stopped
calculating totals. It's a declining balance spreadsheet used for my
business
purchases. There are simple formulas to calculate column totals and then
others to do simple subtraction for the declining balance. Did I turn
something off by mistake that made this sheet do this? It worked fine when
I
tested it and for about 6 months afterward and then suddenly stopped. Now,
if
I go back to a previous entry and delete it and/or change it, nothing
happens
to the totals that have already been calculated. I'm stumped.