Remove Excel 365 Worksheet protection without password in Excel 2007

Occasional Visitor

I have run into a problem protecting a worksheet.

Running Excel 365, I protected the sheet as usual: Right click on worksheet tab, Click on Protect Sheet, Entered a password anb clicked OK, Confirmed the password and clicked OK and saved the File.


If I open in my Excel 365, when I right click on the worksheet tab and click Unprotect Sheet, I am prompted for the password.


Opening the same file in Excel 2007, I can unprotect the worksheet without being promptered for a password!!



2 Replies
Odd, I wouldn't expect this to happen indeed.


If I may recommend, send the file - workbook / worksheet (without sensitive data) with the problem. Explain your problem based on this file. So we could also check the error here and see where the error can or cannot be.

Additional question: Does this problem only arise with these worksheets? ... or also with other protected worksheets?


This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.


Thank you for you all understanding and patience



I know I don't know anything (Socrates)