Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
I am experiencing a problem with my Excel formula options. I opened a
workbook that was set to manual calculation. I went into formula's , changed it to Automatic, went into Excel options and made sure it was set to automatic. Then saved the file, and exited Excel. I then opened the same workbook back up and it was back to manual calculation. Why won't Excel retain my calculation settings? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
Excel takes this setting from the first workbook opened in a session. This setting applies to all open workbooks in a session, no
matter what their original setting was. -- Kind regards, Niek Otten Microsoft MVP - Excel "TeresaD" wrote in message ... |I am experiencing a problem with my Excel formula options. I opened a | workbook that was set to manual calculation. I went into formula's , changed | it to Automatic, went into Excel options and made sure it was set to | automatic. Then saved the file, and exited Excel. I then opened the same | workbook back up and it was back to manual calculation. Why won't Excel | retain my calculation settings? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
I know, I completely exited Excel and I made sure that the file I saved as
Automatic Calculation was the first file I opened when I got back into Excel, and it still opened in Manual Calculation. "Niek Otten" wrote: Excel takes this setting from the first workbook opened in a session. This setting applies to all open workbooks in a session, no matter what their original setting was. -- Kind regards, Niek Otten Microsoft MVP - Excel "TeresaD" wrote in message ... |I am experiencing a problem with my Excel formula options. I opened a | workbook that was set to manual calculation. I went into formula's , changed | it to Automatic, went into Excel options and made sure it was set to | automatic. Then saved the file, and exited Excel. I then opened the same | workbook back up and it was back to manual calculation. Why won't Excel | retain my calculation settings? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
Maybe there's a Workbook_Open event that is setting the calculation
mode to manual? --JP On Jan 28, 10:32*am, TeresaD wrote: I know, I completely exited Excel and I made sure that the file I saved as Automatic Calculation was the first file I opened when I got back into Excel, and it still opened in Manual Calculation. |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
How do I check that? I am using Excel 2007.
"JP" wrote: Maybe there's a Workbook_Open event that is setting the calculation mode to manual? --JP On Jan 28, 10:32 am, TeresaD wrote: I know, I completely exited Excel and I made sure that the file I saved as Automatic Calculation was the first file I opened when I got back into Excel, and it still opened in Manual Calculation. |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
Ugh, sorry can't help you there. I am using XL 2003.
Can you press Alt-F11 to access the VB Editor and check the "ThisWorkbook" module for that workbook to see if there is any code there? It would look like this: Private Sub Workbook_Open() HTH, JP On Jan 28, 1:06*pm, TeresaD wrote: How do I check that? *I am using Excel 2007. "JP" wrote: Maybe there's a Workbook_Open event that is setting the calculation mode to manual? --JP On Jan 28, 10:32 am, TeresaD wrote: I know, I completely exited Excel and I made sure that the file I saved as Automatic Calculation was the first file I opened when I got back into Excel, and it still opened in Manual Calculation.- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
Atl-F11 did opent he VB editor and there was some "test" macros in there. I
just deleted them and now it seems to be working. Thanks. "JP" wrote: Ugh, sorry can't help you there. I am using XL 2003. Can you press Alt-F11 to access the VB Editor and check the "ThisWorkbook" module for that workbook to see if there is any code there? It would look like this: Private Sub Workbook_Open() HTH, JP On Jan 28, 1:06 pm, TeresaD wrote: How do I check that? I am using Excel 2007. "JP" wrote: Maybe there's a Workbook_Open event that is setting the calculation mode to manual? --JP On Jan 28, 10:32 am, TeresaD wrote: I know, I completely exited Excel and I made sure that the file I saved as Automatic Calculation was the first file I opened when I got back into Excel, and it still opened in Manual Calculation.- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
Manual Calculation
Glad to hear it!
--JP On Jan 28, 2:40*pm, TeresaD wrote: Atl-F11 did opent he VB editor and there was some "test" macros in there. *I just deleted them and now it seems to be working. *Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
manual calculation mode | Excel Discussion (Misc queries) | |||
Automatic/Manual Calculation | New Users to Excel | |||
Calculation set as Manual | Excel Discussion (Misc queries) | |||
Manual / Automatic Calculation | Excel Discussion (Misc queries) | |||
Manual calculation does not work | Excel Discussion (Misc queries) |