How do I remove a password on an excel document when I don't know.

We have had an employee leave and have gone to use work spreadsheets which
this employee applied passwords to. Now we can't make corrections. If we
can not get in we will have to re-do all the spreadsheets

Not being funny here, but have you contacted the ex-employee and asked them?

I'm not aware of any way around the password sadly.

"Trish35" wrote:

> We have had an employee leave and have gone to use work spreadsheets which
> this employee applied passwords to. Now we can't make corrections. If we
> can not get in we will have to re-do all the spreadsheets

I wish you could edit posts in here...........anyway:
Assuming you can get into the file, and only the sheets are protected:
Highlight the whole sheet using CTRL+A, open a new Excel file and paste
everything in.

"Phil Osman" wrote:

> Not being funny here, but have you contacted the ex-employee and asked them?
>
> I'm not aware of any way around the password sadly.
>
> "Trish35" wrote:
>
> > We have had an employee leave and have gone to use work spreadsheets which
> > this employee applied passwords to. Now we can't make corrections. If we
> > can not get in we will have to re-do all the spreadsheets

At my work they had the same problem. I searched the Internet for password crackers and found several, one of them UZC.exe. I've tried them all, but UZC did the trick for me.
So try Google.

If you mean workbook or worksheet passwords, check out check out
http://www.mcgimpsey.com/excel/removepwords.html for information.

If you mean file passwords, I think you will need to buy a password cracker.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Trish35" <[email protected]> wrote in message
news:[email protected]...
> We have had an employee leave and have gone to use work spreadsheets which
> this employee applied passwords to. Now we can't make corrections. If we
> can not get in we will have to re-do all the spreadsheets

For about US$40, there are services that will remove a file password in
3 minutes or less. See:

http://mcgimpsey.com/excel/fileandvbapwords.html

In article <[email protected]>,
"Bob Phillips" <[email protected]> wrote:

> If you mean file passwords, I think you will need to buy a password cracker.

Google it! Try to search for "password Excel" You will get stacks, some
free, some not. I downloaded one today. Cracks file and workbook passwords

"JE McGimpsey" wrote:

> For about US$40, there are services that will remove a file password in
> 3 minutes or less. See:
>
> http://mcgimpsey.com/excel/fileandvbapwords.html
>
> In article <[email protected]>,
> "Bob Phillips" <[email protected]> wrote:
>
> > If you mean file passwords, I think you will need to buy a password cracker.
>