Peterson50
asked on
How to unprotect Excel 2013 Spreadsheet
We have a shared spreadsheet that an area of it is protected or at least that is what it says. But the unprotect option is grayed out. This is in Excel 2013. I click on Review and the option is not there although Excel says when I try to go directly to that cell area to turn off protection. I'm not an Excel expert is there somewhere else that it could be.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Created in Excel 97 - Right click on it does nothing. The cell pointer will stay in a cell that is editable. They are using the shared worksheet feature turned on in Excel, Shared Worksheet. There is no enable editing button when it loads.
It exists simply on a shared drive.
It may be easier to recreate the spreadsheet than correct it.
It exists simply on a shared drive.
It may be easier to recreate the spreadsheet than correct it.
Shared = Corrupt as suspected.
ASKER
Recreated file
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for Peterson50's comment #a40362859
for the following reason:
It was the only solution
Accepted answer: 0 points for Peterson50's comment #a40362859
for the following reason:
It was the only solution
Recreating the file may be the only solution to the problem but that does not mean that the insight/advice given is not worthy of points.
What do you see when you right click those ceels, go to Format Cells and then go to protection?? Is the locked box ticked?