Excel calculates non active WS;s

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,