Dan LeVasseur
There are a variety of reasons that Auto-Save may not be showing up:
AutoSave is enabled when working on a file that is saved to OneDrive, OneDrive for Business, or SharePoint Online. If the file is saved to another location, then AutoSave is disabled. This will happen if your file is on a SharePoint On Premises site, a file server, or saved to a local path like C:\.
There are other reasons AutoSave could be disabled as well. Here is a list of common reasons for it to be disabled:
-
Your file is in an older format like .xls, .ppt, or .doc.
-
Your file is in a local OneDrive folder and OneDrive is paused.
-
Your file is being synced by an older version of the OneDrive sync client. For more information on updating OneDrive, see Get started with the new OneDrive sync client in Windows.
-
Your file is embedded inside another Office file.
-
Your presentation is in slide show mode.
If you are using Excel, and tried the above, you may have a file that contains features that are not supported by AutoSave. Do one or more of the following to enable it:
-
Turn off the Shared Workbook feature. This feature is an older method of sharing. It has many limitations, and has been replaced by co-authoring.
-
If possible, remove password encryption from the file: Go to File > Info > Protect Workbook. Then delete the password and click OK.
-
If possible, remove restricted access: Go to File > Info > Protect Workbook > Restrict Access and click Unrestricted Access.
-
If you are opening a workbook snapshot from SharePoint, choose to open the file instead of the snapshot.
-
Turn off the Refresh data when opening file setting on all tables and PivotTables in the file. Select the table or PivotTable, then go to Table Tools Design > Refresh > Connection Properties. Then uncheck Refresh data when opening file.
-
Inactivate an add-in that's causing AutoSave to be disabled. Select File > Options > Add-Ins > Excel Add-ins > Go and then clear the check box for the add-in.