File Sharing Problems

How to Fix Excel Co-Authoring and AutoSave Issues in SharePoint

Rana Garcia Oct 13, 2026 868 views

Question details

Users are prompted to save a copy of an Excel workbook in SharePoint despite AutoSave being enabled, preventing real-time collaboration.

How to Fix Excel Co-Authoring and AutoSave Issues in SharePoint

Product: Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Multiple users attempting to simultaneously co-author an Excel workbook stored on SharePoint.
Observed behavior: Excel prompts users to 'save a copy' instead of auto-saving, often triggered by co-authoring conflicts from PivotTables, filters, or sorting.

Before you start

Ensure that all users have the latest version of Excel installed, a stable internet connection, and that the file is saved in the modern .xlsx format, as older formats like .xls do not support real-time co-authoring.

Solution 1Recommended

Modify PivotTable Settings and Remove Unsupported Features

Disable custom lists in PivotTables and clear conflicting settings that block Excel's AutoSave and real-time co-authoring functions.

Excel co-authoring can be disrupted by features that are not fully supported during simultaneous editing. PivotTable sorting, complex conditional formatting, and certain filters can create synchronization conflicts, forcing Excel to prompt users to save a separate copy.

Access PivotTable Options

Open the affected Excel workbook stored in SharePoint. Click any cell inside your PivotTable, navigate to the 'PivotTable Analyze' tab on the ribbon, and click on 'Options'.

Adjust Totals & Filters

In the PivotTable Options dialog box, navigate to the 'Totals & Filters' tab.

Disable Custom Lists

Under the Sorting section, uncheck the box labeled 'Use custom lists when sorting', then click 'OK' to apply the changes.

Review Workbook Formatting

Check the workbook for complex conditional-formatting rules and active sheet filters. Simplify or remove them where possible, then test the workbook with multiple users to confirm AutoSave remains active.

Modify PivotTable Settings and Remove Unsupported Features

Managing Filters: If users need to filter data without affecting others, recommend using 'Sheet Views' (View > Sheet View) instead of applying standard filters directly to the worksheet.

Solution 2

Remove Custom Views from the Workbook

Custom Views are not supported during co-authoring and will disable AutoSave. Removing them restores real-time sharing functionality.

Free Microsoft Office alternative

Experience Seamless Collaboration with WPS Office

If SharePoint co-authoring conflicts persist in Excel, consider switching to WPS Office. It offers a free, lightweight, and highly compatible alternative with robust cloud collaboration features, allowing multiple users to edit spreadsheets simultaneously without 'save a copy' errors.

Free and lightweight office suite with a familiar user interface.Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Built-in WPS Cloud enables real-time spreadsheet co-authoring without sync conflicts.Seamless migration from your existing Office documents.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep asking me to save a copy in SharePoint?

This happens when Excel's AutoSave encounters a co-authoring conflict. It is commonly triggered by unsupported features like strict file permissions, legacy shared workbooks, or a user filtering/sorting a PivotTable while others are editing the same file.

Does conditional formatting affect co-authoring in Excel?

Yes, complex, overlapping, or frequently changing conditional formatting rules can cause synchronization issues during real-time co-authoring, which may lead to locked files or 'save a copy' prompts.

How can multiple users filter data in Excel without causing conflicts?

To prevent filtering conflicts in a shared workbook, users should utilize the 'Sheet View' feature under the View tab. This allows individuals to create their own custom filters and sort data without disrupting the view or editing capabilities of other co-authors.

Document & File Issues