XLSX File

Hi

I have been given an excel file that requires editing but its locked

I can open the file and re-save it but a lot of cells are not selectable, when I click "unlock", it asks me for a password which me or the user doesn't have

I have googled it for a while tried a couple of downloads but to no avail

Help please....
Thanks

Find more posts tagged with

Free for TechExams community: Cybersecurity salary guide

Compare cert salaries and plan your next career move

Button

Comments

jibbajabba

Without having the file myself and run it through some "password recovery" tools myself I won't be able to help myself.

Obvious solution is of course asking the person who gave that file to you for the password - SOMEONE got to have it surely ...

Lee H

Gomjaba wrote: »

Without having the file myself and run it through some "password recovery" tools myself I won't be able to help myself.

Obvious solution is of course asking the person who gave that file to you for the password - SOMEONE got to have it surely ...

Yes I agree that would be the easiest solution

One particular tool reported to have opened it but when I tried it said corrupted, so am not sure if they even work

I did find one website that said this.....

1、Rename the file to .zip, for example, test.xlsx rename to test.zip.
2、Unzip the .zip file, then open \xl\worksheets\sheet1.xml (if sheet1 has password).
3、Delete this code: <sheetProtection password=…….. />, save.
4、Zip the folder to test.zip, the rename it to test.xlsx.
5、Enjoy

I can locate the code but its longer than what's stated in step 4, mine is this

<sheetProtection password="E38B" sheet="1" scenarios="1" selectLockedCells="1"/>

Once removed the file becomes corrupt

Any ideas?

N2IT

Lee H wrote: »

Yes I agree that would be the easiest solution

One particular tool reported to have opened it but when I tried it said corrupted, so am not sure if they even work

I did find one website that said this.....
1、Rename the file to .zip, for example, test.xlsx rename to test.zip.
2、Unzip the .zip file, then open \xl\worksheets\sheet1.xml (if sheet1 has password).
3、Delete this code: <sheetProtection password=…….. />, save.
4、Zip the folder to test.zip, the rename it to test.xlsx.
5、Enjoy

I can locate the code but its longer than what's stated in step 4, mine is this

<sheetProtection password="E38B" sheet="1" scenarios="1" selectLockedCells="1"/>

Once removed the file becomes corrupt

Any ideas?

Can you **** the spreadsheet into Access and then reimport into another sheet?

Do you have macros created or formulas on this spreadsheet? Is it a fullblown workbook?

I am just wondering the situation you are in before I make suggestions.

RobertKaucher

Or save as a CSV?

N2IT

Another thing I would like to know is this workbook ever stored on a network share?

Who is the owner of the workbook/speadsheet?

And like Robert said, can you try to save it in another file format CSV, XLS, XLSM, anything like that.

tiersten

Lee H wrote: »

I can locate the code but its longer than what's stated in step 4, mine is this

<sheetProtection password="E38B" sheet="1" scenarios="1" selectLockedCells="1"/>

Step 3 in your instructions is just an abbreviated indication of what you're supposed to search for. Its not the actual full statement...

Lee H

A lot of the cells are editable apart from a large table with many figures in it

I would love it if I could keep the formulas

How can the table be locked for editing but not anything else?

tiersten

Lee H wrote: »

A lot of the cells are editable apart from a large table with many figures in it

I would love it if I could keep the formulas

How can the table be locked for editing but not anything else?

You can protect specific portions of a worksheet as well as the whole file.

drainey

You can try this one (password.xla). I have used it successfully to remove the password protection on a worksheet. It claims to work with workbooks also but that I haven't had any luck with.

Excel password: Excel password remover

Good luck.

Lee H

drainey wrote: »

You can try this one (password.xla). I have used it successfully to remove the password protection on a worksheet. It claims to work with workbooks also but that I haven't had any luck with.

Excel password: Excel password remover

Good luck.

Get following error, maybe becase its an XLSX file

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

blargoe

Try this

Excel Password Recovery Instructions

I have also had success in the past resolving weird Excel issues by simply opening the file in OpenOffice, saving it, and then opening it again in Excel.

Lee H

Update on this....I was able to unlock using

Excel Password Recovery

It claims to be thee only application that can unlock 2007-2010 documents and it does work!!!

Thanks for your help people!!