This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is there a way to allow certain people to edit a shared excel sheet, and certain people to view-only, without password protecting the sheet? I was able to do this in Google Sheets, but I don't know if this is an option for Excel.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Again - I don't have the same view that you do.
Manage access and there you can change edit to view only mode. See image below for your reference:
Hi Michelle_1234,
Thanks for sharing updates with us and I really appreciate your effort and your precious time doing those tests. First, please accept my apologize you meet such an issue and I understand it effort on your daily work.
Regarding to, "If users have previously been given editing access, is it possible to change their access to read-only?" if your shared workbook shared and stored in OneDrive then right- click on Exxcel shared file>Manage access and there you can change edit to view only mode. See image below for your reference:
Hi Michelle,
In the link you provided, you are using Anyone can access link.
This type of sharing link, won't be allowed to toggle between edit/view after created.
In your case, you mentioned you would like to let a group of people with edit access to your file, while another group of people with view permission.
You may click on the Plus icon to grant the permission to the specific people one by one:
You can toggle the permission for each person.
Regards,
Alex Chen
Thanks for the quick reply!
Yes, that is what I am trying to do. If users have previously been given editing access, is it possible to change their access to read-only?
Hi Michelle_1234,
First, my pleasure to assist you.
As per your description, please don’t worry, we can work together to narrow down and resolve the situation.
it seems you want to restrict some users to view only excel files and others to edit without password protecting the sheet. May I know if my understanding is correct? if so, the simple way is you can share a same file in a view only mode via uncheck option "Allow editing" while sharing a file from OneDrive. And for the users you want to allow edit the workbook you may check the same option "Allow editing". For reference: Share and collaborate with Excel
Or you could do it is changing the permissions on the document to view for all some members. Then create a SharePoint permissions group called "Excel Edit" and add that into the excel file that you want to be editable and give edit permissions to that group.
I appreciate your understanding and stay safe!!
Best regards
Waqas Muhammad