|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 28th, 2008, 03:20 PM
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
January 28th, 2008, 03:24 PM
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
January 28th, 2008, 03:32 PM
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
January 28th, 2008, 05:59 PM
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
January 28th, 2008, 06:06 PM
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
January 28th, 2008, 06:24 PM
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
January 28th, 2008, 07:40 PM
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
January 28th, 2008, 08:54 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
