Forum Discussion
Excel - Protection Query
Morning,
I am looking for some guidance on the following:
I have an Excel document that I want specified individuals to be able to read it only but all others cannot open it. I will be the only one who can make changes to it. Is there a way to do this?
Thanks.
3 Replies
Yes, you can restrict access to an Excel document with Power Query to specific individuals using Information Rights Management.
You can use the following steps to do so:
- Open the Excel document with Power Query.
- Select File > Info.
- Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access.
- In the Permissions dialog box, select Restrict permission to this workbook, and then assign the access levels that you want for each user.
- You can also use the Protect Document option in Excel 365 app to restrict access and give permission to specific people (via email addresses) the permission to just read (not edit, print, or copy) content. Click More Option for additional restrict permission e.g. user does not print content.
I hope this helps.
- Hi,
I was able to use the Protect Document option to restrict access & it worked perfectly. Thanks for your help, I would not have been able to figure this out myself.
Cheers.- You are welcome :),
I am glad that I could be of help in your project.
I wish you continued success with Excel.
