Forum Discussion

batilmoore's avatar
batilmoore
New Contributor
6 years ago

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
    5 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.

tristaanogre's avatar
tristaanogre
Esteemed Contributor

Where did you download the test data from?  Did they provide a password for you to access the spreadsheet?  What code did you try?  Keep in mind, using VBA for Excel is going to have some mixed results because the syntax and available objects aren't going to be there.

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

Where did you download the test data from?  Did they provide a password for you to access the spreadsheet?  What code did you try?  Keep in mind, using VBA for Excel is going to have some mixed results because the syntax and available objects aren't going to be there.

It is from a personal website who writes posts about big data. I already asked the owner but no reply yet.

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    5 years ago

    Thanks tristaanogre! 

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

    • batilmoore's avatar
      batilmoore
      New Contributor
      5 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
        SmartBear Alumni (Retired)
        5 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.