cancel
Showing results for 
Search instead for 
Did you mean: 

Excel worksheet can not be edited

SOLVED
Highlighted
New Contributor

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 this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Re: Excel worksheet can not be edited

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.

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

6 REPLIES 6
Highlighted
Community Hero

Re: Excel worksheet can not be edited

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.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
New Contributor

Re: Excel worksheet can not be edited


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

Highlighted
Community Manager

Re: Excel worksheet can not be edited

Thanks tristaanogre! 

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


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Highlighted
New Contributor

Re: Excel worksheet can not be edited


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

Highlighted
Community Manager

Re: Excel worksheet can not be edited

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.

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

Highlighted
New Contributor

Re: Excel worksheet can not be edited


@TanyaGorbunova 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

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors