Excel 2003 Recalc

[couimet]

I recently had my office laptop upgraded from Office 2000 to Office
2003. I quickly noticed that Excel 2003 does a recalc everytime I open
a goup/outline. Excel 2000 didn't do that Excel 2002 on my home PC
doesn't do that either.

Anyone else encounter this? How does one "fix" this?

 

[Dave Peterson]

One of the differences between xl2003 and earlier versions is that the worksheet
function =subtotal() changed.

If you used =subtotal(9,a2:a10), it would evaluate to show the sum of A2:A10
ignoring those rows that were hidden by a filter.

xl2003 added another option:
=subtotal(109,a2:a10)
Using 109 means that excel will now ignore those rows hidden manually or via the
filter.

My guess is that excel always recalculates because hiding/unhiding rows could
change this kind of formula.

I don't know a way to change the behavior back to what you want. You could turn
calculation to manual. Do all you want--but remember to recalc before you need
to trust any value that could have changed.

 

[couimet]

Thanks Dave.

This spreadsheet has no SubTotals, just groups to tuck away details.

 

[Dave Peterson]

I don't think it matters if that function is used. Excel will recalculate just
in case it's there.