'%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 Label Filters Showing Date Options
Question details
The user needs to resolve an issue where PivotTable label filters are incorrectly showing date-based filtering options instead of text-based filtering options.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Attempting to filter text data using label filters within an Excel PivotTable.
- Observed behavior
- Excel displays date options such as Before, After, Tomorrow, and Next Week instead of the expected text options like Begins With, Ends With, and Contains.
Save your current Excel workbook and ensure your Mac is connected to a stable internet connection to check for software updates.
Update Excel for Mac to Version 16.86 or Later
This issue is a known software bug in older versions of Excel for Mac. Microsoft officially resolved it in version 16.86 (released May 10, 2024), so updating your software will restore the correct text filters.
If you are running a version of Excel for Mac older than 16.86, the application incorrectly interprets text labels as dates within the PivotTable filter menu. The only permanent fix is to apply the Microsoft Office update.
Launch Microsoft Excel on your Mac and open any existing workbook, or create a blank one to access the top menu.
Click on 'Help' in the top macOS menu bar, then select 'Check for Updates' from the dropdown menu to launch the Microsoft AutoUpdate tool.
Wait for the tool to find the latest updates. Ensure the update for Excel is version 16.86 or higher, then click 'Update' to install it. Restart Excel once the update is complete to see the correct text filter options.
Use WPS Office as a Bug-Free, Lightweight Alternative
If you are tired of dealing with unexpected update bugs and filter errors in Excel for Mac, consider switching to WPS Office. It provides a highly compatible, free, and lightweight spreadsheet alternative with reliable PivotTable features for macOS.
- 1. Download WPS Office: Visit the official WPS Office website and download the macOS installation package.
- 2. Install and Launch: Run the downloaded installer, follow the on-screen instructions, and open WPS Office.
- 3. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheets and manage your PivotTables without encountering date filter bugs.
Frequently Asked Questions
Why is my Excel PivotTable showing date filters for text data?
This is a recognized bug in certain versions of Excel for Mac (specifically before version 16.86). The software misidentifies the text data type in your PivotTable labels, defaulting the filter menu to date-specific options.
How do I check my current version of Excel for Mac?
Open Microsoft Excel, click on 'Excel' in the top-left corner of your Mac's menu bar, and select 'About Microsoft Excel'. A dialog box will appear showing your current version and build number.
Will updating my Excel app break my existing PivotTables?
No, updating Microsoft Excel to version 16.86 or newer only patches the application's code to fix the filter menu bug. Your underlying data, workbook structure, and PivotTable layouts will remain completely unaffected.
