 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / January 2008Manual 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? 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.  SignatureKind regards, Niek Otten Microsoft MVP - Excel |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? 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. > 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. [quoted text clipped - 5 lines] > | workbook back up and it was back to manual calculation. Why won't Excel > | retain my calculation settings? Maybe there's a Workbook_Open event that is setting the calculation mode to manual? --JP On Jan 28, 10:32 am, TeresaD <Tere...@discussions.microsoft.com> 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. How do I check that? I am using Excel 2007. > Maybe there's a Workbook_Open event that is setting the calculation > mode to manual? [quoted text clipped - 6 lines] > > Automatic Calculation was the first file I opened when I got back into Excel, > > and it still opened in 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 > How do I check that? I am using Excel 2007. > [quoted text clipped - 10 lines] > > - Show quoted text - 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. > Ugh, sorry can't help you there. I am using XL 2003. > [quoted text clipped - 21 lines] > > > > - Show quoted text - Glad to hear it! --JP > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.