Skip to content
Excel Off The Grid Logo
  • Home
  • Blog
  • Courses
  • Books
  • Consultancy
  • Member Login

Category: PivotTables

Clear old items from a PivotTable filter list

Clear old items from a PivotTable filter list

Posted on January 6, 2022October 31, 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

Posted in Blog, PivotTables Leave a comment

Awards

Microsoft MVP:

Where to find me

YouTube:

 

Twitter:
Follow @exceloffthegrid

Books

100 Excel Macros Book

Tell me more…

Recent Posts

  • How to fix the Formula.Firewall error in Power Query (2 ways)
  • Advanced dynamic array formula techniques (3 methods)
  • How to use dynamic arrays with other features (7 scenarios)
  • RANDARRAY function in Excel (How to + 4 Examples)
  • SEQUENCE function in Excel (How to + 5 Examples)
Theme by Out the Box
  • Home
  • Blog
  • Courses
  • Books
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact

14-Day Free Trial
Is the Automation Academy right for for you? Try it for free!   

Get started
X