Calculation set to automatic switches

[R4ym0nd]

I'm having a hard time with this calculation options thingy in Excel 2007. I
was having no problem with Excel 2003. Every time I set the calculation
options to automatic, it only performs the calculation at that time, whenever
I enter new values or formulas it won't work, it has already switched to
manual.
I know in excel 2003 these preferences are not saved in the application
itself, rather than in the workbook I'm working with. So what I did is I
changed to automatic, input some information, made sure it was still on
automatic, saved the wb, closed excel. Then I opened the workbook, it's on
automatic, I input some information formulas are supposed to calculate
from... nothing happens, it's switched back to manual.
Does anyone know a fix for this? I have no macros in the wb, only simple
excel formulas.

 

[Roger Govier]

Hi Raymond

Calculation mode is determined by the first workbook opened in an Excel
session.
I suspect that you have a Personal.xlsm file that is being opened
automatically, which has Calculation set to Manual.
Unhide that workbook, set its calculation mode to Automatic>Save the
file>hide Personal.xlsm>Close Excel.

Try opening again and see if you have the same problem.

 

[R4ym0nd]

I checked and there is no Personal.xlsm workbook...
I tried creating a new one, setting the calculation to automatic, but this
option keeps changing after the first calculation takes place :S
I even tried with this macro command but it doesn't work.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.Calculation = xlCalculationAutomatic
End Sub

Any help would be greatly appreciated.

 

[Roger Govier]

Hi Raymond

Do you want to mail me a copy of the problem file, and I will take a look.
To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address