Fix Excel Shared File "See Just Mine" Filter Not Working
Question details
The user is experiencing an issue where the "See Just Mine" personal filter feature in a shared Excel file fails to work, resetting the column filters instead.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook and attempting to use personal sheet views to filter data without affecting others.
- Observed behavior
- Selecting the "See Just Mine" option resets the column filters entirely instead of applying the expected personal filter view.
Ensure your internet connection is stable so the shared workbook can sync properly with the cloud, and save a local backup copy of the workbook before troubleshooting.
Update Microsoft Excel to the Latest Version
This specific filter reset behavior was a known bug that has been addressed in recent Office updates. Updating your software should resolve it.
Microsoft has acknowledged this synchronization glitch in shared workbooks. Installing the latest patch usually restores the correct functionality of the "See Just Mine" feature.
Open Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.
Click on 'Update Options' next to the Office Updates section, and select 'Update Now' from the drop-down menu.
Wait for the update process to finish. Once completed, close and reopen Excel, load your shared workbook, and test the 'See Just Mine' filter again.

Verify Shared Location and Contact Support
If updating does not work, verify the file's hosting environment or escalate the issue to Microsoft Support.
Try WPS Office for Seamless Spreadsheet Collaboration
If Microsoft Excel bugs are disrupting your team's workflow, WPS Office offers a powerful, lightweight, and completely free alternative. Experience seamless collaboration and flawless spreadsheet management without the frustration of complex support tickets.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Files: Launch WPS Spreadsheets and open your existing Excel workbooks directly. No file conversion is necessary.
- 3. Collaborate Instantly: Use WPS Cloud to share the document link with your team and start collaborating without filter reset glitches.

Frequently Asked Questions
Why does the "See Just Mine" option not appear in my Excel workbook?
This feature is only available for workbooks stored on OneDrive or SharePoint. If your file is saved locally on your hard drive or a standard network drive, the Sheet Views functionality will be disabled.
Can I save my custom filter view in a shared Excel file?
Yes. Under the 'View' tab, click 'New' in the Sheet View group. You can configure your filters and then click 'Keep' to save and name your specific view for future use without disrupting other users.
Does clearing the browser cache help if I am using Excel for Web?
Yes. If you encounter the filter reset glitch on Excel for Web, clearing your browser's cache and cookies or testing the file in an Incognito/Private window can often resolve temporary synchronization anomalies.
What should I do if the file keeps refreshing on its own while filtering?
If co-authoring is active and someone else sorts or filters the default view, it may force a refresh. Ensure all collaborators are actively using the 'Sheet View' feature so everyone's independent filters remain uninterrupted.




