Eric_MUC Wrote:
Hi Daniel,

there's an easy way - without any programming... ;)

Simply load the file and (unfortunately you'll have to wait this time
till'
it has calculated - have you every tried to hit "Esc" during
calculation?)

Now, you select "Tools" - "Macros" - "Visual Basic-Editor".
In the Project Explorer you'll see the sheets of your workbook.
Select the one which has these tremendous calculations.
Now you should see in the properties of the sheet the property
"EnableCalculation".
Set this to False and you're done.

Now the sheet only calculates if you hit "F9"... ;)

Hope this helps and best wishes,
Eric


"Daniel Bonallack" wrote:

I have a large file which I open frequently, and it drives me crazy
if I
forget to turn off automatic calculation, as it can take 10 minutes
to
calculate - I usually crash out of Excel to stop it.

I added code to switch calculation to manual as the workbook opens,
but
unfortunately, that workbook_open procedure seems to fire after the
workbook
has been through the calculation process. Is there any code that
runs
immediately when a file is opened?

Thanks in advance
Daniel


HI I´m trying to use option of setting enablecalculation to false, but
when I reopen the document this property is set to true again. I´m
saving the document after setting enable calculation to false, but it
doesn´t work.


--
RSantos
------------------------------------------------------------------------
RSantos's Profile: http://www.excelforum.com/member.php...o&userid=31240
View this thread: http://www.excelforum.com/showthread...hreadid=511965