Recalculation on hiding rows in Excel 2003
 

Hi!

I'm having the issue described in KB918621 where hiding rows in Excel 2003
causes a recalculation of the entire worksheet. Since my spreadsheet
contains 1500 rows and nearly 840 subtotals, this takes close to 20 minutes...
I could use the suggested workaround of disabling automatic calculation but
this is a bit extreme.
The only alternative I can think about is to set up macros to turn this
feature on and off and link them to toolbar buttons.
Can anyone think of anything better?
Thanks in advance for any help you can offer.

Best wishes,

Andrew

Recalculation on hiding rows in Excel 2003
 

Nel post
*Cantoris* ha scritto:

Hi!

I'm having the issue described in KB918621 where hiding rows in Excel
2003 causes a recalculation of the entire worksheet. Since my
spreadsheet contains 1500 rows and nearly 840 subtotals, this takes
close to 20 minutes... I could use the suggested workaround of
disabling automatic calculation but this is a bit extreme.
The only alternative I can think about is to set up macros to turn
this feature on and off and link them to toolbar buttons.
Can anyone think of anything better?
Thanks in advance for any help you can offer.

Best wishes,

Andrew

Hi Andrew,

AFAIK the only two alternatives are those you said: to turn off automatic
calculation or to use a macro to turn on/off automatic calculation. As an
example the macro could be something like this:

Sub SwitchCalculation()


With Application
If .Calculation = xlCalculationAutomatic Then
.Calculation = xlCalculationManual
Else
.Calculation = xlCalculationAutomatic
End If
End With

End Sub



--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy