Solved

Forgot Excel Spreadsheet Password

Posted on 2000-04-24
5
771 Views
Last Modified: 2008-03-17
Is there a way to find out the password on an Excel Spreadsheet?   I know there is code to do this for an Access Database, so I was hoping there would also be a way to get the Excel password...
0
Comment
Question by:TISS
  • 3
5 Comments
 
LVL 4

Accepted Solution

by:
Noggy earned 70 total points
ID: 2743936
If it's a password-on-file-open, here's a link for you: http://www.lostpassword.com/msofpass97.htm
You'll need to pay though. Other than using this tool (or one like it), there's not much of a hope.

If the password is only for protecting the worksheet, you can copy the contents of the worksheet to a new worksheet.

If the password is for protecting the workbook structure, you will probable need to repeat the above for all worksheets i.e. you will be recreating the workbook.

If you've lost the code password, you are basically lost. However, you may be lucky and find the password using a binary editor. That is if the user has embedded the password in the code too.

I hope this helps.
0
 
LVL 9

Expert Comment

by:antrat
ID: 2744236
Hi Tiss

This one is pretty good and it's free for a trial


http://www.elcomsoft.com/ae95pr.html

antrat

0
 
LVL 4

Expert Comment

by:Noggy
ID: 2744355
TISS - Note the following with Antrat's suggestion though.
Unregistered version shows the password which contain 3 charactrs
or less, and the hex representation is not shown at all. To get
passwords of any length (in ASCII and hex forms), please consider
purchasing the full version.

If the file is not a Excel document, or created in newer version
of Microsoft Excel (Excel 97 or Excel 2000), or doesn't have the
password at all, an appropriate message will be displayed. To
recover passwords for Excel 97/2000 documents, please use
"Advanced Excel 97 Password Recovery" program which is available
at:

http://www.elcomsoft.com/prs.html

Please note that if the file you're recovering the password for
is created in non-English version of Microsoft Excel, AE95PR may
say that this document is not password-protected at all. If
you'll get such message, please send us your file -- we'll
recover the password for it manually, and build-in the support
for such files into the next versions of AE95PR.

[Extracted from their ReadMe file].
0
 

Author Comment

by:TISS
ID: 2780524
Thanks.
0
 
LVL 4

Expert Comment

by:Noggy
ID: 2781488
No. Thank you :-).
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question