'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac PivotTable Filters Showing Date Operators
Question details
Users need a solution for a bug where PivotTable text fields incorrectly display date-specific filter operators.
- Product
- Microsoft Excel for Mac
- Device & OS
- Mac
- Scenario
- Filtering text-based fields within a PivotTable to analyze data.
- Observed behavior
- The filter menu incorrectly displays date operators such as 'After', 'Between', 'Tomorrow', and 'This Week' instead of expected text operators like 'Contains' and 'Begins With'.
Check your current Excel version by clicking 'Excel' in the top Mac menu bar and selecting 'About Microsoft Excel' to verify if you are running a version older than 16.85.
Update Excel for Mac to Version 16.85 or Later
This is a known Microsoft bug that has been officially resolved in Excel for Mac version 16.85.
Microsoft identified an issue where the filtering engine misinterpreted text fields as dates in certain Mac versions. Updating your software applies the official patch.
Launch Excel for Mac, click on 'Help' in the top menu bar, and select 'Check for Updates'.
If an update is available, click 'Update' to install version 16.85 or a newer release.
Once the installation is complete, restart Excel and check your PivotTable filters to ensure text operators like 'Contains' have returned.
Use a Slicer as a Temporary Workaround
If you cannot immediately update Excel, using a slicer allows you to filter text fields without relying on the bugged drop-down menu.
Use WPS Office for Reliable PivotTable Data Analysis
If you are experiencing persistent bugs in Excel for Mac, WPS Office provides a free, lightweight alternative with robust PivotTable features and full compatibility with Microsoft Office formats.
- 1. Download WPS Office: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Install and Launch: Follow the standard Mac installation prompts, then open WPS Spreadsheets.
- 3. Open Your Spreadsheet: Open your existing .xlsx file to seamlessly continue your PivotTable data analysis with the correct text filters.
Frequently Asked Questions
Why do my PivotTable text filters show date options like 'Tomorrow'?
This is caused by a known software bug in older versions of Excel for Mac (prior to 16.85), where the application's filter engine misidentifies text data as date values. Updating to the latest version applies Microsoft's official fix.
Can I manually change the data type to fix the filter?
In this specific Excel for Mac bug, manually reformatting the source data columns to 'Text' usually does not restore the correct text filter operators. You must either update the Excel application or use a slicer as a workaround.
How does a slicer help with this filtering issue?
A slicer bypasses the standard drop-down filter menu entirely, providing visual click-buttons for each text entry in your field. This avoids the bugged date operators while still allowing you to accurately filter your PivotTable.
