Pivot Table Issues

How to Fix Excel Sheet Views Not Isolating Slicers in Shared Workbooks

Maira Mehtab Sep 22, 2026 869 views

Question details

Users need to filter PivotTables using slicers in a shared workbook without affecting the view of other collaborating users.

Product: Microsoft Excel (SharePoint)
Device & OS: not provided
Scenario: Filtering PivotTables using slicers within Temporary or Sheet Views in a collaboratively shared SharePoint workbook containing Power Query data.
Observed behavior: Slicer selections are not isolated to the active Sheet View; instead, they remain shared and affect the data view for all users currently in the workbook.

Before you start

Before attempting workarounds, ensure that your SharePoint workbook changes are fully synced and check if standard report filters can meet your data segmentation needs instead of visual slicers.

Solution 1Recommended

Use Report Filters Instead of Slicers

Since Sheet Views have known limitations with slicers, using standard PivotTable report filters can offer better control and avoid disrupting other users.

Sheet Views in Excel have a known architectural limitation where slicer selections cannot be isolated per user when interacting with PivotTables and Power Query data. To avoid changing the view for everyone, you must use alternative filtering methods.

Access PivotTable Fields

Click anywhere inside your PivotTable to reveal the PivotTable Fields pane on the right side of your screen.

Move Fields to Filters

Drag the desired field from the field list into the 'Filters' area at the bottom of the pane instead of creating a Slicer.

Filter the Data

Use the new filter dropdown that appears at the top of your PivotTable to segment your data independently.

Known Limitation: Microsoft currently does not support isolated slicer states in Sheet Views. Submitting feedback through the Excel Help menu can encourage developers to prioritize this feature.

Solution 2

Create Separate Workbook Copies for Independent Analysis

When visual slicer interactions are strictly required for each user, creating personalized copies of the workbook is the most reliable method.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Management with WPS Office

If shared Excel workbooks and Sheet View limitations are slowing down your team's data analysis, try WPS Office. It provides a lightweight, highly compatible alternative for viewing, analyzing, and managing complex spreadsheets without the heavy overhead.

1. Download WPS Office: Visit the official WPS website and install the free suite on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your downloaded .xlsx workbook.
3. Analyze Data Independently: Utilize the built-in PivotTable and filtering tools for isolated, conflict-free data analysis.

Highly compatible with Microsoft Excel (.xlsx) formats and standard PivotTablesLightweight and fast, ensuring smooth performance even with large data setsFree to use with an intuitive, familiar tabbed interfaceEasily perform independent data analysis locally without complex shared workbook conflicts

microsoft office alternative - wps office

Frequently Asked Questions

Why do my slicer selections affect other users in Excel Sheet Views?

Excel Sheet Views currently have limitations with PivotTables and slicers. Slicer states are shared at the workbook level rather than the view level, meaning any selection made by one user will propagate to all other users, even if they are using a temporary Sheet View.

Does Power Query affect how Sheet Views work in shared Excel files?

Yes, workbooks containing Power Query data connections or complex Data Models often restrict certain collaborative features. This includes the ability to properly isolate slicer views and temporary sheet views among multiple users simultaneously.

Will Microsoft fix the slicer isolation issue in Sheet Views?

This is currently a known limitation by design in Excel's collaborative environment. Users are highly encouraged to submit feature requests directly to Microsoft via the Help > Feedback menu in Excel to advocate for isolated slicer functionality in future updates.

Excel & Data Problems