Office Settings & Configuration

Fix Excel Sheet View 'Do This Just for Me' Not Working

Huda QurayshiHuda Qurayshi Nov 3, 2026 868 views

Question details

The user is unable to use the 'Do This Just for Me' prompt to privately filter and sort data within a shared Excel workbook.

Fix Excel Sheet View 'Do This Just for Me' Not Working
Product
Microsoft Excel
Device & OS
not provided
Scenario
Filtering and sorting data in a shared workbook without disrupting the view of other active collaborators.
Observed behavior
The automatic 'Do This Just for Me' prompt is failing to appear or function, preventing the user from creating a private data view.
Before you start

Ensure your Excel workbook is saved in a cloud location like OneDrive or SharePoint, and that AutoSave is turned on, as Sheet Views are only supported in active co-authoring environments.

Solution 1Recommended

Manually Create a Temporary Sheet View

Bypass the automatic prompt by manually triggering a new personal sheet view from the ribbon.

When the 'Do This Just for Me' popup fails to appear after you attempt to filter shared data, you can manually activate a temporary personal view. This ensures your data manipulation remains entirely private.

1
Navigate to the View Tab

Open your shared workbook in Excel and click on the 'View' tab located in the main top ribbon.

2
Create a New View

Look for the 'Sheet View' section, typically found on the far left side of the View ribbon. Click the 'New' (or 'New+') button.

3
Apply Private Filters

Excel will switch to a temporary view, indicated by dark row and column headers. You can now sort and filter your data freely; these changes will only apply to your screen.

4
Exit or Save the View

When finished, click 'Exit' in the Sheet View ribbon group to return to the default shared view, or click 'Keep' to save this view for future sessions.

Sheet View Availability: If the 'New' button is grayed out, check your internet connection, ensure the file is an .xlsx format, and verify that the file is hosted on Microsoft 365 cloud services.
Filter Data Easily with WPS Office

Sort and Filter Data Seamlessly in WPS Spreadsheet

If you frequently encounter frustrating synchronization or view issues in Excel, try WPS Spreadsheet. It offers powerful, user-friendly data management features allowing you to effortlessly sort, filter, and analyze large datasets.

  1. 1. Open Your Workbook: Launch WPS Office and open your .xlsx spreadsheet file.
  2. 2. Select the Data Range: Highlight the headers or the specific range of cells you wish to organize.
  3. 3. Enable the Filter Tool: Navigate to the 'Data' tab on the top ribbon and click the 'Filter' icon to apply drop-down arrows to your columns.
  4. 4. Sort and Analyze: Use the drop-down arrows to quickly sort A-Z, Z-A, or filter out irrelevant data points for your analysis.
100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight software with fast loading times for large and complex datasets.Intuitive data filtering and sorting tools that require no learning curve.Free to download and use with premium features available.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Sheet View 'New' button grayed out in Excel?

The Sheet View feature is strictly available for Microsoft 365 subscribers working on documents saved in SharePoint or OneDrive with AutoSave enabled. If you are offline, using an older Excel version, or working on a local file, the feature will be disabled.

Does creating a new Sheet View affect other users in the workbook?

No. When you enter a temporary or saved Sheet View, your sorting and filtering actions are kept entirely private. Other co-authors will continue to see the default view or their own customized views.

How do I save my temporary Excel Sheet View for later use?

While your temporary view is active, go to the View tab, find the Sheet View group, and click 'Keep'. You can then type a custom name for the view. This allows you to select it from the view drop-down menu anytime you reopen the workbook.