Combining outline levels and autofilters

[Kafrin]

OK, so I have a worksheet with a header row and several hundred rows of data below. The data has been grouped using Excel's Outline & Grouping feature.

I have also turned on the AutoFilter. One of my columns contains either a Y or N for each row and is usually filtered to N using the AutoFilter.

Here's my problem. If I apply the AutoFilter and then click an Outline level, I see all rows for that level, not just the N rows. Similarly, if I click an Outline level and then apply the AutoFilter, I see all the N rows and not just the ones for the level.

What I want to do is apply both the AutoFilter and Outline level (in either order) and then see only the filtered rows for the chosen level. So how can I get the AutoFilter and Outline levels to play nicely together?

I can't easily use code to sort this out as it has to work for people who have macros switched off.

Currently the workbook is in Excel 2003, but if there's a solution in 2007 I can upgrade the workbook. Currently I experience the same problem in both versions.

[Kafrin]

I'm still looking for help on this. Anyone got any ideas?