| 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 | |||
Linear Mode
