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

  • Thread starter Thread starter SER
  • Start date Start date
S

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