Forum Discussion
Pivot table filters not offering text format options like Begins with
I have 3 columns of data, as set of system names, the versions they are at and who's responsible for them. I create a pivot table counting the number of systems at each version.
I then want to filter to only see the the systems that begin with "PRD". I select the filter next to the Systems column, Select field=Machine and Filter > By Label, but rather than the text options I expect, like Begins with, Does Not Begins with, but I only see date related filters (Before, After, Between etc).
Likewise Filter > By Value only shows number related filters (Equals, Greater than etc).
I've tried making sure that column of data is formatted as Text (in the data and the pivot table) - though I didn't do this previously when it was working. I'm using Excel Version 16.84 (24041420).
Any suggestions?
rachel_alderman This is a bug due to a recent update of Excel for Mac. Can't remember exactly in which version it began. But an update to 16.86 on May 10 seems to have resolved the issue.
Edit May 15, 2024: Just read on another forum that version 16.85 may have already resolved it.
3 Replies
rachel_alderman This is a bug due to a recent update of Excel for Mac. Can't remember exactly in which version it began. But an update to 16.86 on May 10 seems to have resolved the issue.
Edit May 15, 2024: Just read on another forum that version 16.85 may have already resolved it.
- Thanks - I've upgraded, but the highest it finds for me atm is 16.85, which still has the issue.
- I've tried upgrading again today (using the `preview` channel), but the latest update available is still 16.85.2 (24052614) which still has the issue.
