how can i set excel 2007 to do a "calculate on open"?

[SER]

When I open Excel itself - it opens fine.
When I open an excel file - it will not open until I right click and select
'calculate'.
Can anyone tell me why? Or How do I set a default "calculate on open"?
Thanks
SER

 

[Barb Reinhardt]

It sounds like you have calculation set to manual. I'm not sure how to
change it in Excel 2007, but if you copy this in the Immediate window of the
VBE and press enter, it should also work

Application.Calculation = XLCalculationAutomatic

 

[ShaneDevenshire]

Hi,

I'm not positive recalculation mode is your problem since you say everything
works OK if you open it from inside of Excel.

But you turn on calculation mode in 2007 by choosing Formulas, Calculation
Options, Automatic.