How to calculate only selected sheets

[kelly mort]

Hi,
My workbook is growing and the calculations is slowing me down.

Is there a way to calculate only some sheets in the workbook?

I will be glad to know about that.

Thanks in advance
Kelly

 

[Joe4]

You need to be really careful about doing that if your have intersheet dependencies in your formulas (that is, some formulas reference other sheets).
Take a look at this discussion here: https://www.mrexcel.com/forum/excel...n-certain-work-sheets-manual-calculation.html

 

[kelly mort]

Okay thanks. The link was very useful to me. I am still working around it. When I get bigger challenges I will report back here.