AutoSave disabled for larger Excel files in SPO. What actually causes it?

Osment Jacquelynn 0 Reputation points
2026-11-19T14:43:28.13+00:00

Hi all,

We have several Excel workbooks stored in SharePoint Online, and AutoSave works normally for most of them. But with some of the larger files, AutoSave just isn’t available, even when opening them directly in the excel desktop app.

Microsoft mentions here that AutoSave can be disabled in certain cases: https://support.microsoft.com/en-us/onedrive/turn-on-autosave-in-microsoft-365-apps

What I can’t figure out is what actually determines this.

Is there a specific file size where AutoSave stops working, or can workbook complexity/features also trigger it? And are there any sharepoint library or site settings that affect this?

Is there anywhere I can see why AutoSave was disabled for a particular file, instead of checking each user’s excel setup individually?

Just trying to understand whether I should be looking at excel, sharepoint, or both.

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments

2 answers

Sort by: Most helpful
  1. Roebe Ta 2,180 Reputation points Independent Advisor
    2026-11-19T15:24:13.8333333+00:00

    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.

    Was this answer helpful?

    0 comments No comments

  2. Adeel Khan 735 Reputation points
    2026-11-19T15:12:25.8666667+00:00

    There is no single file size cutoff published in the Microsoft article you linked. Microsoft only says AutoSave can be disabled for some files, especially large files or files stored on SharePoint, so size is a factor, but it is not the only one. I would compare a working file with one that does not work for format and opening method first. Make sure the file is .xlsx, not an older .xls file, and open it from inside Excel through File, Open, then OneDrive or SharePoint, not from File Explorer or a recent list that points to a local C: path. Also check File, Options, Save, and make sure the AutoSave box is ticked, and check that OneDrive sync is not paused and the Microsoft 365 subscription is active. There is no built-in place in Excel that lists the reason for one file, so I would use that comparison to narrow it down, and look at Excel and SharePoint together, not just one side.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.