SOLVED

Extract data from an inherited drop-down list (locked)

Brass Contributor

Hello!

 

So, I inherited an excel spreadsheet that has a classic drop down. You choose the location, and payment information populates. I can see everything that I need, BUT it is password protected. 

 

What I need to do is extract the data to create a spreadsheet - so essentially a reversal of the data. 

 

I tried to break the password, didn't work. Is there a way, a formula, where I can just say: Pull all the raw data into one file? Is there an easier way then typing out each location (200+) and then LOOKUP? 

 

kittenmeants_0-1700227871640.png

 

1 Reply
best response confirmed by kittenmeants (Brass Contributor)
Solution

@kittenmeants Not sure what method you tried for breaking the worksheet password, but the method I prefer to use is to edit the applicable worksheets .xml file and remove the "<sheetProtection .../>" line of code.

 

A step-by-step guide for this method can be found on Leila Gharani's YouTube channel here: EASILY UNLOCK Protected Excel Sheets WITHOUT Password 

 

If you also need to remove workbook protection (Protect Structure and Windows), use the same method to edit the workbook.xml file and remove the "<workbookProtection .../>" line of code.

 

IMPORTANT: as mentioned in Leila's video, ALWAYS make a backup copy of your file before editing the xml code, in case you inadvertently change or delete something that results in file corruption.

1 best response

Accepted Solutions
best response confirmed by kittenmeants (Brass Contributor)
Solution

@kittenmeants Not sure what method you tried for breaking the worksheet password, but the method I prefer to use is to edit the applicable worksheets .xml file and remove the "<sheetProtection .../>" line of code.

 

A step-by-step guide for this method can be found on Leila Gharani's YouTube channel here: EASILY UNLOCK Protected Excel Sheets WITHOUT Password 

 

If you also need to remove workbook protection (Protect Structure and Windows), use the same method to edit the workbook.xml file and remove the "<workbookProtection .../>" line of code.

 

IMPORTANT: as mentioned in Leila's video, ALWAYS make a backup copy of your file before editing the xml code, in case you inadvertently change or delete something that results in file corruption.

View solution in original post