Forum Discussion
Excel for Mac applying filters to Pivot Table automatically
Hi,
Not super experienced with Excel but my company use a historic document to analyse sales data with a lot of Pivot Tables.
When selecting values with a filter, it is automatically deselecting the values that aren't within the range I've typed in the keyword search:
So I typically enter a MM/YYYY in this box and it lets me deselect values but keeps the remaining values that aren't within the filter selected.
My colleague is running the same version of Excel and I have checked our Pivot Table settings which are identical. Functionality has been fine until Monday when this change seemingly got pushed to my version?
Any help to resolve this would be amazing, and sorry if my explanation isn't very technical!
Thank you
3 Replies
It's still a bug for me as of July 18 2025, how do I get the updated version that has fixed this bug? It makes it very hard to change pivots that are in the same tab as others
As far as I know, this is a bug. Please use Help, Feedback to send feedback to Microsoft about this.
Meanwhile, maybe you can ask your IT dept to roll-back the update?
And this has now been fixed in version 16.96 (released earlier this week - at least it was for me I'm on the beta channel
