Recalc only 1 range of 1 worksheet, other sheets AutoRecalc

[SteveInAlabama]

I have a workbook with multiple sheets used by operators in our factory. One of the sheets has some slow arrays that keep recalcing whenever a cell value is changed anywhere in the workbook, and the recalc bogs down all data entry on the other sheets. (The arrays call data from another source).

What I would like to have happen is that the range with the array (say A1:B100) on the heavy-duty sheet doesn't recalc except by a "Refresh" pushbutton, and the rest of that sheet as well as the others Automatic recalc so the users don't have to know about F9? Is this possible? If not, any workarounds? Now I'm wondering if I moved the array to a separate sheet by itself.... I'm not at work to try that.

 

[Oaktree]

You can't have automatic calculation refer to only certain sheets, but you could set calculation to manual and use worksheet_change and worksheet_activate events to run activesheet.calculate on those worksheets you want to pseudo-automatically calculate.