Forum Discussion
dizzimare38
Mar 31, 2021Copper Contributor
Can open a protected workbook with password but cannot unprotect it -says password incorrect
Hi,
I have a file that has been workbook protected. I input the password and it opens it up (if i type the password wrong it doesn't open up as expected). But I wish to unprotect the workbook so I click review protect workbook and the pop up comes up "unprotect workbook", I enter the same password and it says the password is incorrect. I have even copied and pasted it so it allows me to open the workbook just not unprotect it. Any ideas how to remove the password please? I have office 365 and the workbook I have is opened in the desktop version.
Many thanks.
scaffnull Yes, it is possible, you can use text anchors/links in "Text" web part for this. Follow this:
- Go to Link here page & make "Link test 1 here" as a heading (Heading 1 or 2 or 3) instead of Normal text:
- Republish the page, navigate to heading and mouse hover over the heading, you will get the link to heading:
- You can right click on the link icon & "Copy link address" OR just click on link icon & in browser URL you can find direct URL to this heading. Something like this:
https://contoso.sharepoint.com/sites/spconnect/sitepages/testmodernpage.aspx#link-test-1-here​
- Note # part of above URL. Use this URL on "Test 1" page to link it to second page:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
2 Replies
Sort By
The password required to open a workbook is specified in the Save As dialog.
The password required to unprotect the workbook is specified in Review > Protect Workbook.
These passwords are not related, so they are usually not the same.
You'll have to know the password specified in Review > Protect Workbook to unprotect it.
- dizzimare38Copper Contributor
HansVogelaar that makes sense thank you. Hadnt thought of that. Your help is greatly appreciated! Thank you.