Auto Filter Not Responding (First Post)

[SkyDiver]

Hi All,
This is my first post here. I've got an interesting problem. I have
forecasting worksheet where I forecast the P&L of segments o
customers.

There are probably 900 total segments. I summarize them with a numbe
of subtotals, but in order to work on just the segments without th
subtotals, I filter on a specific column that only has data if it is
segment row. (Did everybody follow me there?)

The problem I'm encountering is that once I filter down to th
segments, the drop-down filter buttons stop working. Nothing happen
when I try to click on them.

When I remove the filter, all the hidden rows remain hidden. I have t
manually unhide them.

I have used variations of this same spreadsheet for years and have no
encountered this problem before--or at least rarely.

Does anyone know how to prevent it?

Thanks,
Georg

 

[Dave Peterson]

It sounds like you're using a combination of Data|subtotals and
Data|Filter|autofilter.

Using those outlining symbols to the left of the row numbers and the filter
arrows could do what you describe.

I think I'd use one or the other (subtotals or autofilter), but not both.

or expand all the outlines and use autofilter
or showall the data in the autofilter and use subtotals
But try not to use them at the same time.

=subtotal() reacts to the hidden rows in data|autofilter and you may be getting
results you didn't expect.