Calculate individual sheets?

[Jase]

I have a large workbook compiled of about 15 sheets. A lot of the sheets are
calculated off each other but I wanted to know if I can calculate an
individual sheet with out having to calculate the entire workbook?

I sthis possible?

thanks,

Jase

 

[Luke M]

It's possible. From the VBA editor (Alt+F11) you can select the different
sheet modules, and then under properties (usually located in bottom left
corner) you can change the "EnableCalculation" setting to either true or
false for the individual sheets.

Due note that if your sheets have formulas that interlink to other sheets,
this could cause unpredicatable results.