Don't Calculate Unless On Sheet

[EnigmaMatter]

Hello,

I have a Sheet with 27,000 formulas. It causes the document to open slowly.

Is it possible to avoid calculations on that Sheet only upon opening, and only calculating when I activate the Sheet?

[Pauleyb]

Yes, it is possible, but there are some potential 'side effects'. Event handlers could be written to turn on manual calculations and then perform calculations when the sheet is activated or the workbook is opened. The problem is that switching to manual calculation occurs at the application level, so every excel workbook you have open would require user interaction to re-calculate. Worse, in my mind at least, is that the current setting is stored with each workbook. So, any workbook you save while the calculations are manual, will be saved with manual calculations. When Excel opens its first workbook, the workbook calculations setting becomes the setting for any subsequent workbooks are opened (regardless of what their saved workbook calculations settings are).

I know, in my case, with a macro as you request, I would end up with a variety of workbooks that have the manual calculations enabled, which would then require me to change the setting. I would argue it is easier to just turn on manual calculations when this workbook is open by yourself so that you then remember to turn on automatic when you are done with this workbook.

[EnigmaMatter]

Stellar points. Will not do this.