Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Calculation
I have a spreadsheet that has manual calculation turned on. My problem is
that after turning automatic calculation on then saving and exiting the spreadsheet this change will not be saved. The next time I open the file manual calculation is on again. I only have this problem on this one particular file. I am wondering if anyone has any ideas for making automatic calculation stay on in this file. Any help at all would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Calculation
This setting depends on the setting in the first workbook opened in Excel. Alls subsequent files opened in the same session will
get that setting until explicitly changed, and then it will be for all open workbooks again. -- Kind regards, Niek Otten Microsoft MVP - Excel "Hawkfan757" wrote in message ... |I have a spreadsheet that has manual calculation turned on. My problem is | that after turning automatic calculation on then saving and exiting the | spreadsheet this change will not be saved. The next time I open the file | manual calculation is on again. I only have this problem on this one | particular file. I am wondering if anyone has any ideas for making automatic | calculation stay on in this file. Any help at all would be greatly | appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic re-calculation | Excel Discussion (Misc queries) | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
automatic calculation | Setting up and Configuration of Excel | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
Automatic calculation | Excel Discussion (Misc queries) |