Manual Calculation

  • Thread starter Thread starter TeresaD
  • Start date Start date
T

TeresaD

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.

--
Kind 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.
 
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
 
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.
 
Back
Top