Can you turn off calculations in a Cell or an entire sheet using code?
I have a spreadsheet that calculates metrics for workers, and I want to use this same workbook to calculate metrics for managers.
The managers portion, however, uses Vlookups which really slow down the system. I'm looking for a way to turn off the manager calculations when checking on the workers metrics and turn them back on when we need to view the managers metrics. The managers calculations are all done on one specific sheet.
I have a spreadsheet that calculates metrics for workers, and I want to use this same workbook to calculate metrics for managers.
The managers portion, however, uses Vlookups which really slow down the system. I'm looking for a way to turn off the manager calculations when checking on the workers metrics and turn them back on when we need to view the managers metrics. The managers calculations are all done on one specific sheet.