Issue summary
When you change from one level of ROW Grouping to another (drilling in or out) - the filter selection remains the same, but is not reflecting in the data that shows. You have to click back into the filter (change nothing) and then it will display
Issue Detail
Data - Autofilter is appliedData has 4 levels of Row grouping (at the top left hand of worksheet there are boxes numbered 1 to 5)
"Include" column in the worksheet which is filtered on "Y"
Every single row of data has either "Y" or "N" in the Inlcude column
Data is set to AUTO calculation.
1. Say you are viewing the data at level 3 of row grouping; if i select "Y" in the inlclude column it correctly shows the ROWS according to the filter
2. If i now change the grouping (for example by clicking the 2 'box/button' in the top left)...
3. Even though the filter is still only selecting "Y" - it shows rows that are also "N"
4. If i click back in the filter column (and do nothing) and then click away....
5. It [magically] shows the correct results again
Non VBA Solution (preferred)
What might be the cause and workaround for this ?
VBA solution
If no solution without VBA....
is there a way to use grouping selection change as the trigger for a macro that refilters the column exactly as it is
I have kept the example simple above for explanation purposes - but it actually wont be "Y" or "N" - it will be 5 different entries such as A,B,C,D,E.
Thank you in advance
When you change from one level of ROW Grouping to another (drilling in or out) - the filter selection remains the same, but is not reflecting in the data that shows. You have to click back into the filter (change nothing) and then it will display
Issue Detail
Data - Autofilter is appliedData has 4 levels of Row grouping (at the top left hand of worksheet there are boxes numbered 1 to 5)
"Include" column in the worksheet which is filtered on "Y"
Every single row of data has either "Y" or "N" in the Inlcude column
Data is set to AUTO calculation.
1. Say you are viewing the data at level 3 of row grouping; if i select "Y" in the inlclude column it correctly shows the ROWS according to the filter
2. If i now change the grouping (for example by clicking the 2 'box/button' in the top left)...
3. Even though the filter is still only selecting "Y" - it shows rows that are also "N"
4. If i click back in the filter column (and do nothing) and then click away....
5. It [magically] shows the correct results again
Non VBA Solution (preferred)
What might be the cause and workaround for this ?
VBA solution
If no solution without VBA....
is there a way to use grouping selection change as the trigger for a macro that refilters the column exactly as it is
I have kept the example simple above for explanation purposes - but it actually wont be "Y" or "N" - it will be 5 different entries such as A,B,C,D,E.
Thank you in advance
