We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

batilmoore's avatar
batilmoore
New Contributor
6 years ago
Solved

Excel worksheet can not be edited

Downloaded a test sheet online t and the data is not editor. It says a password is needed to unlock the protection. I tried some VBA code suggested online but no help.   Any other workaround to fix...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    6 years ago

    Hi batilmoore,

    There is the only one official solution to get access to the Excel - get a password to unlock the file. All other approaches are considered as a hacker attack which we don't support. 

     

    Do you need to use that file for reason? Could you please describe your use case in detail? Perhaps, we can suggest you an alternative solution.

batilmoore's avatar
batilmoore
New Contributor
6 years ago
sonya_m wrote:

Thanks tristaanogre! 

Hi batilmoore , were you able to solve the issue? Please share the results with us! 

No, I am still looking for a way to fix it.

TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
6 years ago

Hi batilmoore,

There is the only one official solution to get access to the Excel - get a password to unlock the file. All other approaches are considered as a hacker attack which we don't support. 

 

Do you need to use that file for reason? Could you please describe your use case in detail? Perhaps, we can suggest you an alternative solution.

  • batilmoore's avatar
    batilmoore
    New Contributor
    6 years ago
    TanyaYatskovska wrote:

    Hi batilmoore,

    There is the only one official solution to get access to the Excel - get a password to unlock the file. All other approaches are considered as a hacker attack which we don't support. 

     

    Do you need to use that file for reason? Could you please describe your use case in detail? Perhaps, we can suggest you an alternative solution.

    it is not open password so i can see view the content. However, no way to make any change. I tried the VBA code with this guide but no help: https://www.instructables.com/id/VBA-Code-To-Unlock-A-Locked-Excel-Sheet/

    p.s it is now fixed with the help of this guide: https://www.androidphonesoft.com/resources/unprotect-excel-sheet-without-password.html