Automatic Calculation on only one Worksheet

[Guest]

Is it possible to have one worksheet in a Workbook calulate manually while
all others automatically? The reason I would like this is I have a sheet
which pulls in real-time market data that slows down my Workbook if
calculation is on automatic for the workbook. If I turn off automatic
calculation for the workbook then I end up spending a lot of time hitting F9
or shift + F9.

Thanks

 

[Niek Otten]

No. But I do think you can with two instances of Excel. Just start another
Excel

 

[Guest]

Thanks but that does not work.

No. But I do think you can with two instances of Excel. Just start another
Excel

 

[Dave Peterson]

You actually started another instance of excel and it didn't work like Niek
suggested?

What happened bad when you tried it?

 

[pinmaster]

Hi, one way would be to create 2 command buttons, one would disable th
other worksheets calculation and the other, enable calculation.

Worksheets(1).EnableCalculation = False
Worksheets(1).EnableCalculation = True

if I'm not mistaken, worksheets are numbered from left to right so i
you wanted to disable the second worksheets you would us
Worksheets(2).

I'm not an expert but I thought it might help!

J

 

[Niek Otten]

To my great surprise that seems to work!
I'll never stop learning (I hope)