'%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 PivotTable Contains Filter Missing or Not Working
Question details
Users are unable to find or utilize the 'Contains' and 'Does Not Contain' text filters when working with Excel PivotTables.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Filtering summarized text data within a PivotTable to display only specific criteria.
- Observed behavior
- Text filters such as 'Contains' and 'Does Not Contain' are entirely missing, not working, or incorrectly replaced by time-based options due to a version-specific software bug.
Check your source data to ensure the target column is formatted purely as text, and note down your current Excel version number before troubleshooting.
Update Excel to the Latest Release
Installing the latest updates often resolves version-specific bugs that cause PivotTable text filters to disappear or malfunction.
Since this issue frequently stems from a known bug in certain Excel releases (particularly noted by Mac users), applying the latest software patches from Microsoft is the most effective way to permanently restore the missing filtering functionality.
Open Excel and navigate to the 'Account' menu (Windows) or the 'Help' menu (Mac) and select 'Check for Updates'.
Click 'Update Now' to download and install any pending software updates.
Restart the Excel application, open your workbook, and click the PivotTable filter dropdown to verify if the 'Contains' option is restored.
Report the Issue via Microsoft Feedback
If updating does not resolve the issue, sending a direct bug report helps Microsoft prioritize a fix for your specific operating system and Excel build.
Test the File in Another Environment
Opening your file in a different version of Excel or an alternative Office suite allows you to apply the necessary filters while waiting for a patch.
Use WPS Office to Filter PivotTable Data Seamlessly
If you are blocked by a version-specific bug in Microsoft Excel that removes essential PivotTable filters, switching to WPS Office provides a stable, lightweight, and free alternative. WPS Office fully supports Excel formats and reliably retains advanced text filtering features like 'Contains' and 'Does Not Contain'.
- 1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your device.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file without worrying about formatting loss.
- 3. Apply Text Filters: Click on the PivotTable dropdown menu to seamlessly access and use the 'Contains' text filters.
Frequently Asked Questions
Why did my PivotTable text filters suddenly change to date filters?
This happens when Excel mistakenly identifies the data type of your source column. If there are dates mixed with text, Excel defaults to time-based filters. Ensure your entire source data column is formatted uniformly as Text before refreshing the PivotTable.
Is the missing 'Contains' filter a known issue on Mac?
Yes, several users have reported that specific updates of Excel for Mac temporarily break or remove the 'Contains' and 'Does Not Contain' filters in PivotTables. Keeping your software updated to the latest build is the best way to receive Microsoft's official patch.
How can I filter data if the 'Contains' option is permanently missing?
As a temporary workaround, you can use the 'Search' box directly inside the PivotTable filter dropdown to find specific text. Alternatively, add a helper column in your source data using the SEARCH or FIND function to categorize the data, then use that new column in your PivotTable.
Will deleting and recreating the PivotTable restore the missing filters?
If the issue is caused by a version-specific application bug, recreating the PivotTable usually will not help. However, if the bug was triggered by corrupted source data formatting, formatting the source as text and rebuilding the PivotTable might restore the filters.
