Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
The calculation option in Excel 2003 keeps switching to Manual. I choose
Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
Calculation is set by the mode in the FIRST file to open.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Erin" wrote in message ... The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
"Erin" wrote:
The calculation option in Excel 2003 keeps switching to Manual. Do you have any macros that might be executed at open time -- either an event or volatile macro or due to a volatile formula? I wonder if a macro is setting manual calculation, then failing to set automatic calculation for any of a number of reasons. ----- original message ----- "Erin" wrote in message ... The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
"Erin" wrote:
The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? Please clarify "when I reopen Excel". Do you mean when you start Excel (blank worksheet)? Or do you mean when you open an Excel workbook? If the latter, are you opening the file within Excel (clicking on File Open), or are you clicking on the file in a folder? In either case, do you already have another workbook open in Excel? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
I'm importing a report from a third party and then running a macro. The
macro has nothing in it about calculation (I created it). But I do usually run this report first thing in the morning, and I haven't checked the calculation status before running it, so maybe it is the report that is doing it. A co-worker has run the report without the calculation status switching, but she runs it later in the day so she has already opened other files. Usually, I won't have Excel open when I download the report -- Excel opens from the report. So tomorrow, I'll try opening another file first and see if this fixes the problem. I can't do anything about the third party report -- the company charge us if we want something modified, but I could add a line to my macro to switch to automatic calculation. "JoeU2004" wrote: "Erin" wrote: The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? Please clarify "when I reopen Excel". Do you mean when you start Excel (blank worksheet)? Or do you mean when you open an Excel workbook? If the latter, are you opening the file within Excel (clicking on File Open), or are you clicking on the file in a folder? In either case, do you already have another workbook open in Excel? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
Just to add to Don's response.
Remember to look for any files in your XLStart folder--personal.xls was saved in manual mode???? Don Guillett wrote: Calculation is set by the mode in the FIRST file to open. -- Don Guillett Microsoft MVP Excel SalesAid Software "Erin" wrote in message ... The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation changing from Automatic to Manual
This fixed it. I was opening the file directly from the source and the
calculation was set to manual. When I opened Excel first and then opened the file, the calculation was set to automatic. Thanks! "Don Guillett" wrote: Calculation is set by the mode in the FIRST file to open. -- Don Guillett Microsoft MVP Excel SalesAid Software "Erin" wrote in message ... The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this problem before -- how to do I make it stay at Automatic? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic/Manual Calculation | Excel Discussion (Misc queries) | |||
Calculation Manual vs Automatic | Excel Discussion (Misc queries) | |||
Calculation - Automatic and Manual | Excel Discussion (Misc queries) | |||
Automatic/Manual Calculation | New Users to Excel | |||
Manual / Automatic Calculation | Excel Discussion (Misc queries) |