-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
autocalc
-
P
Grouping of sheets and enabling/disabling Autocalcs
I have a workbook that is a rollup of analysis on individual assets. There are numerous sheets and many conditional sumproduct summation formulas within each that are slowing down calcs (i believe). I want to be able to turn off the calcs on sheets i am not working on. The workbook contains...- pcomet
- Thread
- autocalc grouping sheets
- Replies: 1
- Forum: Excel Questions
-
R
Macro to hide/show & enable AutoCalc on certain sheets
Hey guys, I have an usual vba question to ask. Is it possible to create a worksheet that acts as a directory for all the worksheets in workbook? I want to be able to use this directory to show/hide certain worksheets & also enable/disable autocalc for certain worksheets as well. I've done a lot...- RPM7
- Thread
- autocalc column directory hide / unhide worksheets worksheets
- Replies: 6
- Forum: Excel Questions
-
M
Groups turn on, autocalc turns off every time I open s/sheet
I have moved to a new computer, and my s/sheets are getting messed up. EVERY TIME I open my main work s/sheet, Groups is enabled and Autocalc is turned off (from Automatic to Manual). Autocalc is set to Auto in Options. Totally screws up my s/sheet, and it is almost unusable. Using Excel 2007...- michaellnb
- Thread
- autocalc groups unwanted
- Replies: 1
- Forum: Excel Questions
