How to disable calculations of a specified sheet

hi folks

I want to disable caculations of a specified worksheet while keep calcuations on other sheets enabled. Anyone has idea about this? Thanks allooooooot!

Hi,

You could turn the calculation on the relevant tab to manual (Tools > Options > Calculation tab) which will then only calculate if you press F9 or on save (if you leave the 'Recalculate before save' option ticked).

Hope this helps,

Robert