How to Use "See Just Mine" Filters in Excel Files Shared on Teams
Question details
Users need to filter and sort shared Excel workbooks in Teams without disrupting the view of other co-authors.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Co-authoring and collaborating on a shared Excel workbook via Microsoft Teams.
- Observed behavior
- Filtering or sorting a shared workbook changes the default view for all other users unless they are actively prompted with "See Just Mine" during simultaneous editing.
Ensure that the Excel workbook is stored in SharePoint or OneDrive, and that co-authoring is enabled for all participants so that Sheet Views function correctly.
Use Sheet Views for Personal Filtering
Creating a personal Sheet View is the most reliable way to filter and sort data without affecting other collaborators.
The 'See Just Mine' prompt automatically appears only when multiple users are actively filtering at the exact same time. If you apply a filter while you are the only one in the document, those changes become the new default view for everyone. To avoid this entirely, use the Sheet View feature.
Open the shared Excel file from Teams in the Excel Desktop App or Excel for the Web.
Navigate to the View tab on the main ribbon.
Click on 'New' within the Sheet View group. The column headers will turn black to indicate you are in a temporary personal view.
Apply your desired filters and sorting. These changes will now only be visible to you.
Click 'Keep' to save this custom view and give it a recognizable name for future use.
Triggering the "See Just Mine" Prompt
Understand how and when the automatic prompt triggers during simultaneous co-authoring.
Collaborate Seamlessly with WPS Office
If Microsoft Excel's shared views and co-authoring prompts are causing friction for your team, try WPS Office. It provides a lightweight, highly compatible alternative with robust cloud collaboration features via WPS Docs, ensuring you can co-edit safely and efficiently.
- 1. Download WPS Office: Download and install WPS Office from the official website to get started.
- 2. Open your workbooks: Open your existing .xlsx workbooks directly in WPS Spreadsheet without losing any formatting.
- 3. Collaborate in real-time: Upload the file to WPS Cloud to enable seamless real-time co-authoring with your entire team.
Frequently Asked Questions
Why doesn't the "See Just Mine" prompt appear when I filter?
The prompt only triggers when two or more users are actively working in the co-authored workbook at the exact same time. If you are the only one in the document, your filter changes are saved as the default view for everyone.
How can I save my personal filter view in Excel?
Go to the View tab and select 'New' under the Sheet Views group. Apply your filters, then click 'Keep' and give your view a specific name. This saves the view so you can easily switch back to it later without affecting other users.
Does the workbook revert to "See Everyone's" when I leave?
If you created a temporary Sheet View (by clicking "See Just Mine"), closing the workbook clears your temporary view. However, if you applied filters while alone in the default view, those filters will persist for the next person who opens the file.
Can I use Sheet Views in the Excel desktop app?
Yes, Sheet Views are available in both Excel for the Web and the Microsoft 365 Excel desktop app, provided the file is saved in SharePoint or OneDrive and co-authoring is supported.
