xl2003 enhanced the =subtotal() function.

You can use
=subtotal(1,a2:a100)
This will look at the cells in A2:A100. It'll ignore the cells/rows that were
hidden by the autofilter.

=subtotal(101,a2:a100)
will look at the cells in A2:A100. But it'll ignore any cell/row that was
hidden by a filter or by hiding the row.

xl2003 always expects/assumes that you'll have some manually hidden rows and
that takes longer to recalc.

You can change calculation to manual, do the filtering, and then back to
automatic.

Tools|options|calculation tab
is where you'd toggle this setting.

Ken wrote:

Excel2003 ...

When Template has various "Filter" Switches activated ... It seems to take
sooooo much longer to "Calculate"???

Any reason for this ... or ... anything I can do to prevent???

Thanks ... Kha

--

Dave Peterson