How to Restore 'Begins With' Text Filters in Excel for Mac PivotTables
Question details
Users are unable to use text label filters such as 'Begins With' in their PivotTables, as the filter menu incorrectly displays date-based filter options instead.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Attempting to filter text labels within a PivotTable to find specific text strings.
- Observed behavior
- The label filters incorrectly show date-style options like 'Before', 'After', and 'Between' instead of expected text filters such as 'Begins With'.
Ensure you have a stable internet connection and have saved your current work, as you will need to download and install a software update for Microsoft Excel.
Update Excel for Mac to Version 16.86 or Later
Installing the latest Microsoft Office update resolves the bug that replaces text filters with date filters.
This specific issue was identified as a software bug in a recent release of Excel for Mac. Microsoft has patched this bug in versions 16.86 (and potentially 16.85). Updating your application will immediately restore normal text filtering functionality in your PivotTables.
Launch Microsoft Excel on your Mac. Click on 'Help' in the top menu bar, then select 'Check for Updates'.
In the AutoUpdate window, let the tool search for available updates. Look for the Excel update labeled version 16.86 or newer and click the 'Update' button.
Once the installation is complete, fully close and restart Microsoft Excel. Open your workbook and verify that text filters like 'Begins With' are now available in your PivotTable.

Verify Source Data Formatting
If updating your software does not immediately fix the issue, double-check that your source data is strictly formatted as text.
Avoid Excel Bugs with WPS Spreadsheet
Tired of software updates breaking essential features? WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office. It seamlessly opens your existing Excel files and allows you to create and filter PivotTables without the hassle of unexpected bugs.
- 1. Install WPS Office: Download and install the free WPS Office suite for Mac.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file containing the PivotTable.
- 3. Filter Your Data: Click the filter icon on your PivotTable labels to easily access and apply 'Begins With' text filters without errors.

Frequently Asked Questions
Why are my PivotTable text filters showing date options instead?
This is caused by a known software bug in a recent update of Microsoft Excel for Mac. The application incorrectly categorizes text fields as dates, which limits your filter options to date-specific criteria like 'Before', 'After', and 'Between'.
Will I lose my PivotTable data if I update Excel?
No, updating Excel using the Microsoft AutoUpdate tool only patches the software. Your workbooks, raw data, and existing PivotTables will remain completely intact.
What if 'Begins With' is still missing after updating to version 16.86?
If the text filter is still missing, ensure your macOS is up to date, try restarting your Mac, or check your source data to confirm the affected column is explicitly formatted as 'Text' rather than 'General' or 'Date'.
Can I use 'Begins With' filters in WPS Office instead?
Yes, WPS Spreadsheet fully supports advanced PivotTable filters, including 'Begins With', 'Ends With', and 'Contains'. Opening your file in WPS Office allows you to bypass the Excel for Mac bug completely.




