Autosave not updating in Sharepoint

Question

Hi all,

I have encountered an issue with one of the users that are updating files in Sharepoint. When the user is accessing the files in Sharepoint, the autosave function is off and when the user tries to turn it on, all of the files that the user is working on will be save in the users Onedrive and not in the Sharepoint file itself. 

Tried resetting Onedrive and Sharepoint to no avail.

Answer 1

Hi joe,

According to your description, Autosave is still off when you open the file from SharePoint. Could you please check the two buttons below is enabled?

Open Excel>File>Options>Save, check whether the button ”AutoSave OneDrive and SharePoint Online files by default on Excel” is enabled.

Click OneDrive icon>Others>Settings>Office, check whether the button ”Use Office applications to sync Office files that I open” is enabled.

About the second image choosing an OneDrive account, prompt user encountered when he turns on AutoSave in Office application is a normal behavior because Office applications needs to verify the account so that the content made will be synced. Prompt doesn’t mean that files are saving to user OneDrive, as we’re syncing the SharePoint Document library with help of OneDrive sync client, it is asking you to select the account.

So you need to select the OneDrive account which is the same as SharePoint, then the change in the opened SharePoint file will still save in SharePoint original location.

Regards,

Jazlyn

Answer 2

Hi joe,

Based on your description, there are two problems when the user use SharePoint online, one is the Autosave functions is off, and the other is that files save in the OneDrive instead of SharePoint when saving.

About “Autosave functions is off”, there are many reasons for it, such as: your file is on a SharePoint on premises site, a file server, some other cloud storage service, or saved to a local path like C:. Here is an official article about the other reasons of “Autosave disabled” for your reference, and you may could find the main cause of this problem.

About “save in the OneDrive”, could you please check the real location where the file stored. Open the file on desktop application>File>Info>Properties>Advanced Properties>General>Location to check whether the files are stored in SharePoint. Also, normally, when the user open the file from SharePoint and the AutoSave is disabled, the user will be prompt to save the file locally when he try to close the document, could you confirm with your users if they have receive that prompt?

If my understanding of the problem is wrong and the problem persists, please do not hesitate to reply to me.

Regards,

Jazlyn

Answer 3

Hi Jazlyn,

Most of the user's Autosave function is on when opening files from the shared folder, apart from this user. Also, everything is syncing when other users are updating the file in the shared folder. It's just that when the user opens the file and turn on the autosave function, the user is getting prompted that the file will be saved in the local one drive and not the file in Sharepoint.

Answer 4

Hi joe,

Thank you for reply.

Based on your description, the problem only happens on a specific user. Then you can try to open the file in browser to see if the file will be saved in SharePoint.

If the file can be saved in SharePoint, then the cause may on the desktop application.

Additionally, could you please provide some information for me?

1. Test result of above suggestion.
2. The screenshot of the prompt.
3. Office version(open Word>File>Account>About Word)

Regards,

Jazlyn

Answer 5

Hi joe,

If you still need further support, please do not hesitate to reply to me.

Regards,

Jazlyn