Turning off calculations on specific tabs

[larsonnj]

I am working with a multi tab worksheet. The first tab is where all the data is input and the rest are a lot of data analysis. When the calculations are running data entry is extremely delayed. When I set Calculation Options to Manual it seems that it does not remain manual if I reopen it. Is there an easier way to simply shut off those specific tabs entirely? It would be nice if they were automatically off when opened and could be turned back on.

 

[JoeMo]

I am working with a multi tab worksheet. The first tab is where all the data is input and the rest are a lot of data analysis. When the calculations are running data entry is extremely delayed. When I set Calculation Options to Manual it seems that it does not remain manual if I reopen it. Is there an easier way to simply shut off those specific tabs entirely? It would be nice if they were automatically off when opened and could be turned back on.

Not that I'm aware of.

When you open a workbook with one or more other workbooks open, Calculation in the workbook you open will be set to whatever setting is in effect prior to the open, even if Calculation was set to Manual when you saved and closed the workbook. You can add Workbook_Open event code to your workbook so that Calculation is set to Manual after the workbook is open, but even then, if other workbooks are open and Calc is automatic prior to the open event, your workbook will calculate before the code sets Calc to Manual.

I try to remember to set Calc to Manual when I open a workbook I don't want to calculate on opening.

 

[Taul]

Hi,
You can automatically turn a page tab or several page tabs to manual with a workbook open event.
Then use a sheet activate to turn specific page tabs back to automatic when the sheet is selected.

take a look at this thread
http://www.mrexcel.com/forum/excel-questions/503284-prevent-excel-updating-inactive-worksheets.html

 

[Taul]

Taking into account JoeMo's point about other workbooks being open at the same time, is that likely to be an issue for you?
I had not considered other workbooks being open