Forum Discussion

Bayleyvilla's avatar
Bayleyvilla
Copper Contributor
Jan 09, 2022
Solved

Excel Protect Sheet not working with password

I have used protect sheet for years just to stop people changing things. All of a sudden when i choose protect sheet ( with no password ) it works If i enter a password it asks for it again then a ...
excel
  • NikolinoDE's avatar
    NikolinoDE
    Jan 09, 2022

    Bayleyvilla 

     

    As I informed you before

    First make a update, then Office repair.

    Click on the links to get more information about it.

    Did you manage this?

     

    Please include your operating system (Win.10 Pro, Win 10. Home, Win.10 Enterprise, etc.), storage medium (hard drive, OneDrive, Sharepoint, etc.).

     

    Sample file (with out sensitive data)

    Drag and drop here or browse files to attach
    Maximum size: 71 MB • Maximum attachments allowed: 5
     
    Additional questions: Is the problem only on this file? ... or on all files? In which version was the file created? ... is it an xls file that has been converted to xlsx?
     
    I know that it is annoying when you have a problem and instead of an answer you get more questions. But please consider the possibilities in Excel are very diverse, as are the possibilities of the causes.
     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Bayleyvilla's avatar
Bayleyvilla
Copper Contributor
Jan 09, 2022

NikolinoDE 

 

the sheet is now frozen

here is sheet before trying to password protect

sorry the sheet wont attach xlsx not supported

 

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jan 09, 2022

Bayleyvilla 

 

As I informed you before

First make a update, then Office repair.

Click on the links to get more information about it.

Did you manage this?

 

Please include your operating system (Win.10 Pro, Win 10. Home, Win.10 Enterprise, etc.), storage medium (hard drive, OneDrive, Sharepoint, etc.).

 

Sample file (with out sensitive data)

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
 
Additional questions: Is the problem only on this file? ... or on all files? In which version was the file created? ... is it an xls file that has been converted to xlsx?
 
I know that it is annoying when you have a problem and instead of an answer you get more questions. But please consider the possibilities in Excel are very diverse, as are the possibilities of the causes.
 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

 

Resources