How to Use Personal Sheet Views in Coauthored Excel Workbooks
Question details
The user needs to filter a shared Excel workbook independently so that their personal filter does not change the view for other collaborators.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Co-authoring a shared Excel workbook stored in OneDrive or SharePoint.
- Observed behavior
- By default, applying filters in a shared workbook changes the data layout for everyone currently co-authoring the document.
Ensure your Excel workbook is stored in OneDrive or SharePoint and that AutoSave is turned on, as Sheet Views require these specific co-authoring environments to function properly.
Create and Save a Personal Sheet View
Use the built-in Sheet View feature in Excel for the web or Microsoft 365 to isolate your filtering actions without interrupting other colleagues working on the same file.
Sheet View is a feature designed for collaborative environments. It prevents multiple users from clashing by allowing each user to apply custom sorts and filters that only exist on their screen unless deliberately shared.
Open your shared Excel workbook in either Excel for the web or your Microsoft 365 desktop app. Click on the 'View' tab located in the top ribbon.
Click the 'New' or 'Sheet View' button. The row and column headers will turn dark, indicating that you have successfully entered a temporary private view.
Select a private view if explicitly prompted by Excel. Apply your personal filter (for example, sorting your Account Handler column). Your actions will no longer affect other collaborating users.
If you wish to retain this view for future sessions, navigate back to the Sheet View group within the View tab, click 'Keep', and type a recognizable name for your view.
Try WPS Office for Seamless Spreadsheet Collaboration
If you frequently encounter file sharing friction or find Microsoft Office subscriptions expensive, WPS Office provides a free, highly compatible alternative. It comes equipped with WPS Cloud to facilitate robust real-time co-authoring, file management, and independent editing without the heavy resource footprint.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your respective operating system.
- 2. Open existing Excel files: Launch WPS Spreadsheet and securely open your existing .xlsx files directly without losing any original formatting or data.
- 3. Collaborate in the cloud: Upload your file to WPS Cloud, generate a sharing link, and invite colleagues to edit the workbook collaboratively in real-time.
Frequently Asked Questions
Why is the Sheet View option grayed out in my Excel?
Sheet Views are exclusively available for workbooks stored in OneDrive or SharePoint with AutoSave enabled. If you are working on a locally saved file or using an older standalone version of Excel (like Excel 2016 or 2019), the feature will be disabled.
Can I save multiple personal views in one shared workbook?
Yes, you can create and name multiple distinct Sheet Views. This allows you to quickly toggle between various data filter setups without continuously recreating them or affecting other editors.
Are my saved Sheet Views visible to other co-authors?
Yes, any Sheet View you explicitly name and save becomes available to other users in the workbook. They can choose your saved view from the Sheet View drop-down list on their View tab if they want to see the data sorted exactly as you configured it.
How do I exit a personal view and go back to the standard shared view?
To leave your personal view, go to the View tab, locate the Sheet View group, and select 'Default' from the drop-down menu. This reverts your screen to the standard view shared by all users.
