Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Calculation Mode to Automatic without calculating
Hello,
I'm experiencing a huge performance issue when testing a fairly large workbook on XL2003 (vs XL2000). Calculation Mode is set to Automatic. I found out that XL2003 triggers a recalculation when hiding/showing some rows, while XL2000 does not. - Is there a way to make XL2003 behave like XL2000 on this very point? (no calculation upon hide/show rows) If not I'm trying to workaround this (VBA). I can set the calculation mode to Manual right before hiding/showing the rows, and then reset it back to automatic afterwards. My problem now is that XL recalculates when Calculation mode is reset to automatic. Is there a way to reset the Calculation Mode to automatic (I don't want to keep Manual calculation mode) without having XL to recalculate everything? Thanks in advance for your help, Jerome |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual Calculation in Excel 2007 with Calculate mode set to Automatic | Excel Worksheet Functions | |||
Formulas not calculating - Calculation is on Automatic & I pressed | Excel Discussion (Misc queries) | |||
Calculation Mode | Excel Programming | |||
Calculation Mode | Excel Programming | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |