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