Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation set as Manual
Hi,
I'm using Excel 2002 SP3 and the calulation option is set as Manual. When I go and change it to Automatic (which is the way I want it) it works fine until I close and reopen Excel where upon it sets itself back to Manual. How can I set it to save to Automatic? I have, by the way, removed and reinstalled Office, but still the same issue. Thanks for your time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation set as Manual
Make sure your personal.xls or any other workbook which opens when Excel
opens has its setting to Automatic. The setting is determined by the first workbook opened, hidden or not. "Dan." wrote in message ... Hi, I'm using Excel 2002 SP3 and the calulation option is set as Manual. When I go and change it to Automatic (which is the way I want it) it works fine until I close and reopen Excel where upon it sets itself back to Manual. How can I set it to save to Automatic? I have, by the way, removed and reinstalled Office, but still the same issue. Thanks for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
default manual calculation instead of auto in options excel 2003 | Excel Discussion (Misc queries) | |||
Automatic calculation reverting to manual depending upon who opens | Excel Discussion (Misc queries) | |||
My Calculation Mode Changed to Manual Somehow?!? | Excel Discussion (Misc queries) | |||
Manual calculation does not work | Excel Discussion (Misc queries) | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) |