Subtotals and Autofilter Errors Office 2003

[Esteban404]

I have a subtotal level one with the count function on the
categories. Works fine. I add another subtotal using count
on a different column and remove the check mark
from "update subtotals" option and it creates level 2.
Level 2 is correct, but level 1 has been incremented by
the number of rows added to place the new summar line in
for each of the new groups.

Autofilters drop down lists will not show an entry
eventhough it is present. Number of rows is less than 1000
and all of the rows have numeric data.

It happens every time. I didn't find any posts on MSDN.
Anyone know what gives?

Thanks,

E

 

[Dave Peterson]

Subtotals and Autofilter don't always play nice with each other.

=Subtotal() will ignore hidden rows

Autofilter likes to hide rows.

So they're kind of working against each other.

 

[Esteban404]

Problem is that the errors are showing in subtotal and
autofilter sheets exclusively: the subtotal sheet does not
have autofilters on and the autofilters sheet does not
have any subtotals.

the subtotals are being built on top of one another and
are incorrect as they are built down to more detail
Level 1

Level 2
Level 3

Level one and two are incorrect for Count when Level 3 is
created. I can only get good numbers by parsing in code
and skipping the functions altogether... "normal" users
can't do that.

Sounds like a bug to me.

Sn