Excel Restricted Access Workbook Preventing Autosave

Angela Ham 21 Reputation points
2022-09-15T19:10:18.59+00:00

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.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
821 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,640 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Angela Ham 21 Reputation points
    2022-09-22T21:36:27.513+00:00

    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.

    1 person found this answer helpful.
    0 comments
  2. Emi Zhang-MSFT 21,706 Reputation points Microsoft Vendor
    2022-09-16T07:16:47.75+00:00

    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.

    0 comments