Pivot Table Issues

How to Restore 'Begins With' Text Filters in Excel for Mac PivotTables

Natalie TaylorNatalie Taylor Nov 11, 2026 869 views

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.

How to Restore 'Begins With' Text Filters in Excel for Mac PivotTables
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'.
Before you start

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.

Solution 1Recommended

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.

1
Open Microsoft AutoUpdate

Launch Microsoft Excel on your Mac. Click on 'Help' in the top menu bar, then select 'Check for Updates'.

2
Download the Latest Version

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.

3
Restart Excel

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.

Update Excel for Mac to Version 16.86 or Later
Update Successful: After updating to version 16.86 or higher, your PivotTable label filters will correctly identify text fields and provide the appropriate filtering options.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install the free WPS Office suite for Mac.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file containing the PivotTable.
  3. 3. Filter Your Data: Click the filter icon on your PivotTable labels to easily access and apply 'Begins With' text filters without errors.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Stable and reliable PivotTable creation and advanced text filtering tools.Lightweight design that runs smoothly on both Mac and Windows.Completely free to use with a familiar, user-friendly interface.
microsoft office alternative - wps office

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.