A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @Osment Jacquelynn ,
I tested this behavior in my environment with workbooks stored in SharePoint Online, and AutoSave remained available. Based on Microsoft documentation, there is no published file-size threshold at which AutoSave is automatically disabled.
To answer your questions:
- What determines whether AutoSave is available? AutoSave depends on whether the workbook and editing scenario support the cloud-saving and co-authoring capabilities required by the feature. Certain workbook states, file formats, permissions, or unsupported features can prevent AutoSave from being available.
- Is there a specific file size limit? Microsoft does not document a specific file size limit that disables AutoSave. However, workbook complexity may be a factor because larger files are more likely to contain advanced features, external connections, protection settings, or other elements that can affect co-authoring and AutoSave behavior.
- Are there SharePoint library or site settings that affect this? There does not appear to be a SharePoint setting specifically designed to disable AutoSave for large files. However, library configurations that impact editing behavior, such as requiring documents to be checked out, should be reviewed when investigating AutoSave issues.
- Is there a way to see why AutoSave was disabled for a particular file? I am not aware of a centralized SharePoint or Microsoft 365 admin report that exposes the reason AutoSave is disabled for a specific workbook. Typically, the most useful information comes from the Excel client itself, such as messages displayed when hovering over or attempting to enable the AutoSave toggle.
Based on the above, I would recommend focusing primarily on the Excel workbook and its configuration first, while also confirming that the associated SharePoint Online library does not use settings such as required check-out. Since AutoSave is working for some files and not others, the workbook characteristics are likely to be the key differentiator.
I hope this points you to the right direction.