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, 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:


Acquisition International:
Business Excellence Awards 2021

Spreadsheet Instructional Expert of the Year

Where to find me

YouTube:

 

Twitter:
Follow @exceloffthegrid

Books

100 Excel Macros Book

Tell me more…

Recent Posts

  • Get data into Power Query – 5 common data sources
  • Introduction to Power Query
  • VBA Rename File: 5 code examples
  • Remove excess spaces in Power Query
  • CSV to Excel: Power Automate & Office Scripts
Theme by Out the Box
  • Home
  • Blog
  • Courses
  • Books
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact