Excel Info page shows protected workbook, but it isn't

1. I'm the author. I'm not sure if I started it as a .xls,or .ods, but now is .xlsx.

2. .xlsx

3. No, "Unprotect" does not appear, nor the name of any worksheets. It only states that "The structure of the workbook has been locked to prevent unwaranted changes, such as moving, deleting, or adding sheets"

Thanks in advance!

This issue hasn't been solved. Does anyone else has a sugestion?

As per your description, your workbook is protected. If you workbook is protected, you will be shown like below on Info.

Now, unfortunately, it doesn't say Unprotect Workbook, here on Info page. It, only says that Structure of the workbook has been locked...

You will need to go into workbook, Review tab > Protect Workbook (Here also, it will not say Unprotect. In case of Sheet Protection, Unprotect sheet is shown on this tab but not for Workbook if Workbook is protected). The only indication is that this Protect Workbook will be in pressed mode, hence of different colour. (Also, in a protected workbook if you take right click on a tab, most of the options will be disabled)

Once you click on Protect Workbook, you will be asked to supply password to unlock it.

The "Protect Workbook" is not in pressed mode (and I'm not shown an unprotect option only this).

Also, in some sheet's, I cannot see the sheet tab. I supposed it was beecause the strucuture was locked. I can only change to another sheet using keyboard shortcuts.

The "Protect Workbook" is not in pressed mode (and I'm not shown an unprotect option only this).

Hi All,

I have this very same problem.

Two of my workbooks (I am the author and both are *.xlsx files) say on their info pages

"That the structure of the workbook has been locked to prevent unwanted changes etc,etc" (with no option to unprotect from the info page) and if I select "Review" "Protect Workbook" (non coloured "icon") within my workbook I just get the option to protect it.

Anybody found out how to unprotect an unprotected workbook yet.

In the INFO screen where it shows you that your structure is protected and highlighted in yellow, click on the dropdown arrow in the Protect Workbook button to the left of the message.  In the dropdown choose/click on Protect Workbook Structure option.  This is a toggle based on my testing so if you do that and then go to info again it will not show the structure as being protected.

this is assuming no password was set.  It if was, you will need to furnish the password I would guess.

In the dialog that appears in this thread, the Structure option will always be checked - but it is not always in effect.

--

Regards,

Tom Ogilvy

Still having issues myself. This workbook I have for paying bills was created and protect in excel 2013. It has been brought over to excel 2016 when I upgraded this year. Could this be the issue?

I also am having an identical issue.

I can protect and unprotect the workbook all day long, from the review ribbon or the file info.  File info still shows itself as protect workbook highlighted, but the workbook is not protected.

As such, I cannot freeze panes / unfreeze panes, which is what I was trying to do.