Prevent AutoSave from Saving Filters in a Shared Excel Workbook
Question details
The user wants to keep personal filter changes from affecting other people in a shared Excel workbook while AutoSave is enabled.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple people work in a shared workbook and need to filter data independently.
- Observed behavior
- Filter or view changes can be saved by AutoSave and become visible to other collaborators.
Check whether the workbook is stored in OneDrive or SharePoint and whether your Excel version supports Sheet Views. Let collaborators know before changing a shared filter or turning off AutoSave.
Use a Sheet View for independent filtering
Use a Sheet View where supported to apply filters without disrupting other collaborators' views.
Open the workbook from OneDrive or SharePoint in a version of Excel that supports Sheet Views.
Select the worksheet, then go to View > Sheet View > New.
Use the filter arrows in the header row to display the data you need. The filters apply to your active Sheet View rather than the default view.
Go to View > Sheet View > Exit to return to the default view. Keep or name the view if you want to use it again.

Clear the shared filter or turn off AutoSave
Use these workarounds when Sheet Views are unavailable and collaborators can coordinate their changes.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move existing files into WPS. It does not change how AutoSave or Sheet Views work in Microsoft Excel.

Frequently Asked Questions
Can I stop Excel AutoSave from saving filters but keep it on for everything else?
Excel does not provide a standard setting to exclude filter changes from AutoSave. Where supported, use View > Sheet View > New to filter independently instead.
Will clearing a filter undo a change that AutoSave already saved?
Data > Clear removes the current filters, but collaborators may already have seen the filtered state. The cleared state can also be saved when AutoSave is on.
Why can't I find Sheet View in Excel?
Sheet View availability depends on your Excel version and workbook location. Check the View tab and, for a shared workbook, use a supported version of Excel with the file stored in OneDrive or SharePoint.
Can a macro reset filters before a workbook is saved?
A VBA solution can be designed to reset filters during a save event, but it requires development and testing. Macros are not supported in Excel for the web and may not suit every coauthoring workflow.




