Sheet has stopped calculating...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Tools>Options, Calculation tab, check Automatic

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top