Home |
Search |
Today's Posts |
#1
|
|||
|
|||
why have my spreadsheets stopped calculating formulas?
The sheet calculates only those cells that I retype the formula for. If I
change the values again it will not recalculate until I retype the formula again. |
#2
|
|||
|
|||
Most likely, the calculation mode has been set to manual instead
of automatic. Go to the Tools menu, choose Options, then the Calculation tab. There, check the Automatic check box. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dfbaskwill" wrote in message ... The sheet calculates only those cells that I retype the formula for. If I change the values again it will not recalculate until I retype the formula again. |
#3
|
|||
|
|||
"Chip Pearson" wrote: Most likely, the calculation mode has been set to manual instead of automatic. Go to the Tools menu, choose Options, then the Calculation tab. There, check the Automatic check box. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dfbaskwill" wrote in message ... The sheet calculates only those cells that I retype the formula for. If I change the values again it will not recalculate until I retype the formula again. |
#4
|
|||
|
|||
Thank you, I've been going crazy with this. I think Options was the only
thing I didn't try. "Chip Pearson" wrote: Most likely, the calculation mode has been set to manual instead of automatic. Go to the Tools menu, choose Options, then the Calculation tab. There, check the Automatic check box. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dfbaskwill" wrote in message ... The sheet calculates only those cells that I retype the formula for. If I change the values again it will not recalculate until I retype the formula again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Turning off auto unhide when calculating formulas | Excel Worksheet Functions | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Formulas not calculating | Excel Worksheet Functions |