Prevent calculation on open
First of all...............what size of workbook and what types of
calculation take hours and hours?
Maybe you should re-design?
Secondly............Excel takes the calculation mode of the first workbook
opened.
Are you opening another workbook set to automatic calc before opening the
offending workbook?
If that's the case, setting the offender to manual calc means nothing.
Gord Dibben MS Excel MVP
On Tue, 17 Mar 2009 07:18:01 -0700, littlefb
wrote:
I'm using Excel 2007 (which has this in a different place), but I already
tried and it didn't work.
"Stefi" wrote:
Try to set Calculation to Manual before opening this workbook
(ToolsOptionsCalculation tab)!
Regards,
Stefi
„littlefb” ezt írta:
Is there a way to prevent calculations from running when opening a file? I
can't get the file to open at all because the calculations take hours and
hours. I need to prevent them from running as I open the file.
|