How to Fix Excel Sheet View Not Keeping Filters Private in SharePoint
Question details
Users experience an issue where filtering a personal Sheet View in an Excel workbook hosted on SharePoint unexpectedly applies the filter to all other users viewing the file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on shared Excel workbooks in SharePoint using personal Sheet Views.
- Observed behavior
- Even when the personal Sheet View (indicated by the eye icon) is active, applying or changing filters alters the view for everyone else currently in the workbook.
Ensure that you are genuinely in a personal Sheet View (the column headers should have a black background) and check with your Microsoft 365 admin if your tenant has received the latest updates.
Allow Time for Tenant Updates or Open a Support Ticket
This is a known Microsoft bug that was officially patched. If you still experience it, your tenant may need an update push or admin intervention.
Microsoft acknowledged this as a known Excel Sheet View bug and deployed a fix starting February 23, 2021. Because Microsoft 365 updates are rolled out gradually, some tenants experience delays in receiving the patch.
Confirm the issue persists across multiple browsers or private/incognito windows to rule out local caching issues.
Wait 24 to 48 hours to see if the patch naturally reaches and updates your Microsoft 365 tenant.
If the problem continues, contact your organization's Microsoft 365 global administrator for further assistance.
Ask the administrator to navigate to the Microsoft 365 Admin Center and open a formal support ticket to resolve the tenant-specific glitch.
Open the File in the Excel Desktop App
Bypassing Excel for the Web can sometimes prevent view-syncing bugs when working with heavily filtered shared documents.
Try WPS Office for Seamless Spreadsheet Collaboration
If you are experiencing ongoing bugs with Microsoft Office shared views, WPS Office offers a highly compatible, lightweight, and free alternative. It fully supports .xlsx formats and provides robust tools for data analysis without the steep subscription costs.
- 1. Download WPS Office: Visit the official WPS website to download and install the free Office suite.
- 2. Open your spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files with full compatibility.
- 3. Collaborate via WPS Cloud: Save your files to WPS Cloud to enjoy stable, isolated views and seamless team collaboration.
Frequently Asked Questions
Why does my Excel Sheet View affect others in SharePoint?
This usually happens due to a known Microsoft sync bug where personal views fail to isolate filters, broadcasting your local changes to all active co-authors despite the Sheet View being active.
How do I know if I am in a personal Sheet View?
When active, the column headers change to a black background, and an eye icon appears on the sheet tab indicating you are in a temporary or personal view.
Can a SharePoint site owner fix the Sheet View sync issue?
No, site owners cannot fix this backend bug. It requires a patch deployed by Microsoft to the entire tenant, which may require a global administrator to escalate via a support ticket.
