Office Settings & Configuration

Fix Missing Excel Filter Prompt for Shared Workbooks

Steve K Sep 30, 2026 870 views

Question details

The user is unable to see the prompt asking whether to apply a filter for themselves or for everyone in a shared Excel workbook.

How to Fix Missing Excel Filter Prompt for Shared Workbooks

Product: Microsoft Excel
Device & OS: not provided
Scenario: Filtering data in a shared workbook during co-authoring.
Observed behavior: Excel no longer displays the filter prompt to choose between personal or global filters, which affects how filters are applied across different users' views.

Before you start

Ensure that you are working in a shared workbook stored on OneDrive or SharePoint, as collaborative filter prompts only trigger in active co-authoring environments.

Solution 1Recommended

Check and Adjust Sheet View Settings

Determine if the workbook is in a temporary or custom Sheet View, which suppresses the filter prompt, and create a new personal view instead.

When Excel is in a custom or temporary Sheet View, it assumes you are already working in an isolated environment. Consequently, it skips the prompt asking if the filter should apply to everyone.

Check the current view

Navigate to the 'View' tab on the Excel ribbon and locate the 'Sheet View' group to see which view is currently active.

Switch to Default View

If a custom or temporary view is selected, click on 'Default'. Excel displays the filter prompt only when you are in the default view.

Create a New Sheet View

To filter data without affecting others (and without needing the prompt), click 'New' in the Sheet View group. This creates a temporary workspace.

Rename and save the view

Click 'Keep' or enter a new name for the view in the provided text box to save it. You can now apply personal filters in this view without changing the default view for other users.

Understanding Sheet Views: Sheet Views allow you to create customized views of an Excel worksheet without being disrupted by others. Filters applied in a named Sheet View will only affect your display.

Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

Experiencing sync or view limitation issues in shared Excel workbooks? WPS Office provides a lightweight, highly compatible alternative for team collaboration and data management, completely free.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Install and Launch: Run the installer and follow the on-screen prompts. Once installed, open WPS Spreadsheet.
3. Open Your Workbook: Drag and drop your existing .xlsx files directly into WPS Office to continue your collaborative work seamlessly.

Fully compatible with Microsoft Excel (.xlsx) formats.Lightweight design ensures fast loading of large shared workbooks.Free built-in tools for data filtering, sorting, and collaborative editing.Familiar user interface requires no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel sometimes not ask if a filter is for everyone?

Excel skips this prompt if you are already in a custom or temporary Sheet View, as it assumes any filters applied are intentionally meant only for that specific isolated view.

How do I filter an Excel sheet without affecting others?

You can go to the View tab and click 'New' under the Sheet View group. This creates a temporary workspace where your filters and sorts won't disrupt other collaborators viewing the default sheet.

Can I save my personal filter view in a shared workbook?

Yes. Once you create a new Sheet View and apply your filters, you can rename it in the View tab to save it permanently for your own use during future sessions.

What happens if I apply a filter in the Default view?

If you apply a filter while in the Default view of a shared workbook and bypass the prompt, it will typically affect what all other users see, filtering the data globally.

Office App Problems