Solved

Forgot Excel Spreadsheet Password

Posted on 2000-04-24
5
767 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Outlook Free & Paid Tools
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now