Prevent Shared Dashboard Filters From Changing for Everyone in Excel
Question details
The user wants individual dashboard selections in a SharePoint-hosted Excel workbook without changing what other users see.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Multiple people use filters or data-validation drop-downs to view a shared dashboard.
- Observed behavior
- Changing a data-validation drop-down can update the dashboard view for every user.
Check whether the dashboard control is a column filter or a data-validation drop-down in a cell. Sheet View can isolate supported filter and sort changes, but it does not make cell values private.
Use Excel Sheet View for Individual Filter Views
Use Sheet View when users need independent filter or sort settings on a shared worksheet.
Open the workbook from its SharePoint location in Excel for the web or a version of Excel that supports Sheet View.
On the worksheet, select View > Sheet View > New. If Excel prompts you while filtering, choose to create a sheet view.
Use the filter arrows in the table or column headers to choose the rows you want to see. Your filter and sort choices remain in that sheet view rather than changing the default view for everyone.
Use the Sheet View menu on the View tab to switch back to Default or select a saved view.

Give Each User a Separate Workbook for Drop-Down Selections
Use individual copies when the dashboard depends on a data-validation drop-down or another shared cell value.
Create Individual Spreadsheet Views With WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Excel-compatible spreadsheets. Open an existing workbook and create individual copies for users who need separate dashboard selections. WPS does not change how Excel coauthoring works in SharePoint.

Frequently Asked Questions
Why does my dashboard drop-down change the view for everyone?
A data-validation drop-down writes a selection into a worksheet cell. In a coauthored workbook, that cell value is shared, so formulas or dashboard elements that depend on it can update for everyone.
Will Excel Sheet View make a data-validation selection private?
No. View > Sheet View can separate supported filter and sort settings, but it does not isolate edits to cell values. Use individual workbook copies or a dashboard design that stores selections separately.
Can I turn off AutoSave to keep my selection private?
Do not rely on AutoSave as a privacy control. Turning it off may affect coauthoring, and saving later can still write your changes to the shared file. Use a separate copy if the selection must not change the shared workbook.
How do I return to the shared default filter view?
On the worksheet, open View > Sheet View and select Default. Your saved sheet view can be selected again from the same menu.




