ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 326
- Office Version
- 365
- Platform
- Windows
I am using Excel 2010
I have 1 pivot table using 2 slicer objects.
When I use slicer 1 it automatically shows what I can filter in slicer 2.
If I filter in Slicer 2. Everything works great.
When I come back to slicer 1 and select an item that is greyed out. the slicer fails, till you clear the filter in slicer 2.
Is it possible to assign a macro using VBA code that will automatically clear the Manual Filter and still select the object I choose in Slicer 1
I have 1 pivot table using 2 slicer objects.
When I use slicer 1 it automatically shows what I can filter in slicer 2.
If I filter in Slicer 2. Everything works great.
When I come back to slicer 1 and select an item that is greyed out. the slicer fails, till you clear the filter in slicer 2.
Is it possible to assign a macro using VBA code that will automatically clear the Manual Filter and still select the object I choose in Slicer 1
