Excel calculates non active WS;s

[SarahPintal]

hi guys,

I have about 5 worksheets, and 2 of the work sheets have about 20k rows by 10 columns... everytime i change one of the other 3 worksheets a calculation takes places.. is there a way to stop these 2 worksheets from being calculated if they havent been touched?



it is taking about 30 seconds to do the calculation even though i have only changed 1 row on another worksheet.

Thanks in advance,

[jeffreybrown]

Hi Sarah,

Without much to go on here, the first thought that jumps to my mind are maybe volatile formulas in your ss.

Check here >> http://www.decisionmodels.com/optspeedb.htm

[SarahPintal]

Thanks for your response Rocky,

I worked it out: I just disabled the caculation part when i am running the macro (Application.Calculation = xlManual)

thanks for your help

[jeffreybrown]

Glad to hear it worked out Sarah.

Just make sure at the end of the macro to turn the calculations back on!

Application.Calculation = xlCalculationAutomatic