PivotTables - Excel Off The Grid

How To Create Sheets For Each Item In PivotTable Field

November 7, 2023May 4, 2023 by Excel Off The Grid

Some Excel features hide in plain sight. They are there, but nobody thinks to click the button. In this post, we are covering one of those features. We are looking at how to create separate sheets for each item in a PivotTable field with the Show Report Filter Pages feature. Excel users love PivotTables because … Read more

Clear old items from a PivotTable filter list

November 7, 2023January 6, 2022 by Excel Off The Grid

It’s a question that every PivotTable user has had to ask at some point: How to clear old items from a PivotTable filter list? Look at the screenshot below, we can see Delta in the PivotTable filter box and the slicer, but there is no Delta in the source data table. How can that happen? … Read more