Office Settings & Configuration

How to Automatically Open Excel in View Just Mine

Kushani Nimanthika Oct 16, 2026 868 views

Question details

The user wants to configure an Excel workbook to automatically open in the 'View Just Mine' mode for every user.

How to Automatically Open Excel in View Just Mine

Product: Microsoft Excel
Device & OS: not provided
Scenario: Collaborating on shared workbooks and trying to prevent users from disrupting each other's active filters and sorts.
Observed behavior: Excel currently does not offer a built-in automation or setting to force shared workbooks to open directly into the 'View Just Mine' state by default.

Before you start

Ensure you are collaborating on an Excel workbook saved in OneDrive or SharePoint, as Sheet Views are only supported in cloud-stored files with co-authoring enabled.

Solution 1Recommended

Manually Create and Select a Sheet View

While you cannot force Excel to automatically open in 'View Just Mine', you can create a personalized Sheet View and manually select it when working.

Excel manages Sheet Views individually. When a user creates a new sheet view, Excel preserves it as a saved state, but it still defaults to the standard view for everyone upon opening.

Open the shared workbook

Launch Microsoft Excel and open the shared workbook stored on OneDrive or SharePoint.

Navigate to the View tab

Click on the 'View' tab located in the top ribbon menu.

Create a new Sheet View

In the Sheet View group, click 'New'. Excel will immediately switch your screen to a temporary 'View Just Mine' mode with black column and row headers.

Save and name the view

Click 'Keep' in the ribbon, and type a customized name for your view so you can easily select it from the drop-down menu every time you open the document.

Manual Selection Required: Each user must manually select their saved Sheet View from the View tab every time they open the document, as it cannot be set as a permanent default.

Solution 2

Submit a Feature Request to Microsoft

Because automatic enforcement is not natively supported by Excel, submitting feedback can help prioritize this feature in future software updates.

Free Microsoft Office alternative

Enhance Your Spreadsheet Collaboration with WPS Office

If you are looking for a robust, lightweight, and cost-effective office suite, WPS Office provides an excellent alternative to Microsoft Office. It offers powerful spreadsheet tools, seamless file collaboration, and an intuitive interface without the expensive subscription fees.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite.
2. Open Your Excel Files: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks.
3. Collaborate Efficiently: Use WPS Office's built-in sharing features to co-edit and manage data with your team.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Supports seamless document sharing and efficient team collaborationLightweight software that runs smoothly on both older and newer devicesFamiliar user interface ensuring a zero-learning-curve migration

microsoft office alternative - wps office

Frequently Asked Questions

What is 'View Just Mine' in Excel?

'View Just Mine' is a feature within Excel's Sheet Views that allows a user to create custom sorts and filters in a co-authored workbook without disrupting the data layout for other active users.

Why does my Excel file always open in the Default view?

Excel currently manages Sheet Views individually and is programmed to open all workbooks in the standard Default view. It requires users to manually select their custom saved views after the file is opened.

Can a VBA macro force 'View Just Mine' on startup?

Currently, the Excel Object Model does not fully expose Sheet Views to VBA, making it highly unreliable or impossible to force a workbook to enter 'View Just Mine' automatically via a startup macro.

Where are Sheet Views saved?

Sheet Views are saved directly within the Excel workbook structure. Once a custom view is created and named, anyone with access to the cloud file can select it from the Sheet View drop-down menu.

Office App Problems