File Sharing Problems

Prevent AutoSave from Saving Filters in a Shared Excel Workbook

Amos GikundaAmos Gikunda Nov 18, 2026 870 views

Question details

The user wants to keep personal filter changes from affecting other people in a shared Excel workbook while AutoSave is enabled.

Prevent AutoSave from Saving Filters in a Shared Excel Workbook
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.
Before you start

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.

Solution 1Recommended

Use a Sheet View for independent filtering

Use a Sheet View where supported to apply filters without disrupting other collaborators' views.

1
Open the shared workbook

Open the workbook from OneDrive or SharePoint in a version of Excel that supports Sheet Views.

2
Create a Sheet View

Select the worksheet, then go to View > Sheet View > New.

3
Apply your filters

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.

4
Leave the view when finished

Go to View > Sheet View > Exit to return to the default view. Keep or name the view if you want to use it again.

Use a Sheet View for independent filtering
Sheet View availability: Sheet Views depend on your Excel version and workbook location. A named view can be available for others to select, even though they can use their own views independently.
Free Microsoft Office alternative

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.

Filter and review spreadsheet data in WPS SpreadsheetsOpen and edit Microsoft Excel formats such as XLSX and XLSUse a familiar Office-style interfaceMove existing spreadsheets into a lightweight, free office suite
microsoft office alternative - wps office

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.