Excel autosave access from multiple users

Question

Is it possible for different users to use a local file that autosaves to sharepoint?

We have one user that files a daily report with an excel spreadsheet that we need to have on sharepoint so management can review it as needed. That user is a low level user that the company doesn´t want to give access to the sharepoint.

In my pc I can have a local file that i can modify and it gets updated with autosave on a sharepoint folder, is it possible to share the windows folder location so that this user can access it and modify it "locally" and have it update the one in sharepoint?

Answer 1

Hi Pquito,

AutoSave is enabled when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online. AutoSave option is not enabled for the files saved to local drive.

If you do not want to give access of the SharePoint site to the mentioned user, you can consider putting the said Excel workbook in a folder and then share this specific folder with the user. In this way, the user will get the access to the file without getting access to the other resources of SharePoint site. The user then can sync the shared folder on his computer using OneDrive sync client and utilize the AutoSave feature.

Note*: Please put the file in a folder and then share the folder with the user. We can sync an entire folder but not individual file with OneDrive sync client.*

Further, there are some requirements for the user to sync files to a computer from a shared folder in OneDrive for business or SharePoint online. If you are okay to share the SharePoint folder with the mentioned user and the user has any trouble syncing the folder on his/her computer using OneDrive sync client, please provide me with the following information so I can provide the exact information:

1. May I know whether you would be sharing the folder with a Microsoft 365 business or personal account of the user?
2. Is the user an employee of your company or an external user?

Regards,

Neha

Answer 2

Hi Pquito,

Did you check the above reply? If you need any help, please update us when you have time.

Regards,

Neha