Hi Dave,

I tried it - it does....at least in my MS Excel... ;)

Best wishes,
Eric


"Dave Peterson" wrote:

You sure that it calculates when you hit F9??

From VBA's help for the .enablecalculation property:

When the value of this property is False, you cannot request a recalculation.
When you change the value from False to True, Excel recalculates the worksheet.



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


--

Dave Peterson