Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Calculating Time Sheet | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
why have my spreadsheets stopped calculating formulas? | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |