I have 7 slicers, that are connected to 7 pivots which control 7 column charts. Each pivot table has a Row sort (Z to A for a date) and a Column sort (small to large for count of occurrences). The slicer, pivots, and charts are all on the same worksheet. When I use a slicer, it removes the Column sort but the Row sort stays functional. I have exactly the same scenario in other Excel spreadsheet and this doesn't happen. Any help will be greatly appreciated. Thanks, Terry
Slicer use is removing sort settings on pivots
- Thread starter Terry K
- Start date
Chihiro
Excel Ninja
Without sample, hard to say.
Couple of thing you can do.
1. Check Slicer setting in Ribbon tools "Slicer tools" and compare with your other workbook.
2. Record macro when you apply Custom sort. Modify and move it into PivotTable_Update event found in Worksheet Module to preserve custom format after Slicer selection change.
If above does not fix the issue, as last resort, delete pivots, clear cache and rebuild (or start from clean workbook). See if issue is replicated if you change order of set up (Ex. Test1: set up all pivots and apply custom sort, then create slicers. Test2: set up all pivots, apply custom sort AFTER slicers has been set up.)
Couple of thing you can do.
1. Check Slicer setting in Ribbon tools "Slicer tools" and compare with your other workbook.
2. Record macro when you apply Custom sort. Modify and move it into PivotTable_Update event found in Worksheet Module to preserve custom format after Slicer selection change.
If above does not fix the issue, as last resort, delete pivots, clear cache and rebuild (or start from clean workbook). See if issue is replicated if you change order of set up (Ex. Test1: set up all pivots and apply custom sort, then create slicers. Test2: set up all pivots, apply custom sort AFTER slicers has been set up.)