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

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

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

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

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"SER" wrote:

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

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

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.

--
Thanks,
Shane Devenshire


"SER" wrote:

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