The file has ~54,000 rows and 10 columsn of data, and the formula is a 4 part
COUNTIFS. That seemed like a good idea at the time (I think I was tired).
But now I can't get the file to finish opening (it's hogging both processors
completely for hours). I've tried setting the currently open workbook
("Book1") to manual, then open the file - no luck. I've tried using a macro
that first sets Application.Calculation to xlManual, then it opens the file.
Still no luck. I basically need a way for Excel to open the file without
trying to make sense of those formulas.

"Gord Dibben" wrote:

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.