I tried this on the password protected file: copy to a new s/s. It didn't
work for me. It kept the password in the copy, too. Excel 2003 / XP. :(
What am I doing wrong?



"francis" wrote:

Are you referring to sheet protection?
if yes, copy the whole sheet to a new sheet

....
My boss has an excel spreed sheet and put a password protection in it. So
every time he tries to open that particular spreed sheet it will prompt for
password first before the file can actually open. Unfortunately he forgot the
password for it and he did all his passwords and nothing would work.
Is their a way to remove that password. I've tried different password
recovery tool from the internet but nothing works. Any help would be
appreciated.

Thank You