Excel Restricted Access Workbook Preventing Autosave

Question

Hi All,

We are trying to restrict certain people from editing a file in excel while others can edit. When we use the 'restrict access' for certain individuals it removes the ability for the document to autosave. Is there any workaround for this? We need to be able to have multiple people working within the document and have it autosave while also restricting other people from editing. I cannot seem to make that work.

Answer 1

We are using the latest available version of excel and have the spreadsheet uploaded to teams so multiple people can collaborate and work within the document at the same time. The issue is some people change things they shouldn't while others dont. We want to make the document viewable to all within the team however restrict editing capabilities to a select few. From the research I've done, when access is restricted to certain people and open to others, the autosave function doesn't work. Which means you can't have multiple people working within the same document because it's not autosaving.

Answer 2

Hi @Angela Ham ,
What version of Excel did you use?
I suggest you refer to this support article about the Collaborate on Excel Workbook:

https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.