software

We have a large (4,000 rows) excel worksheet from a prior employee that I
would like to be able to use, but it is password protected and no one has the
password. Is there a way to copy or save it as a different file that will
not copy the password protection? It would save me a couple days of work if
it is possible.
Thanks

www.mcgimpsey.com/excel/removepwords.html--

Regards,

Peo Sjoblom

quot;ksmith81quot; gt; wrote in message
...
gt; We have a large (4,000 rows) excel worksheet from a prior employee that I
gt; would like to be able to use, but it is password protected and no one has
the
gt; password. Is there a way to copy or save it as a different file that will
gt; not copy the password protection? It would save me a couple days of work
if
gt; it is possible.
gt; Thanks
gt; We have a large (4,000 rows) excel worksheet from a prior employee that I
gt; would like to be able to use, but it is password protected and no one has the
gt; password. Is there a way to copy or save it as a different file that will
gt; not copy the password protection? It would save me a couple days of work if
gt; it is possible.
gt; Thanks

Hi.
An easy way to do so is:
- Go to the password-protected worksheet
- Press quot;Ctrl Aquot; and then quot;Ctrl Cquot; (to copy all the contents of the worksheet)
- Open and go to a new Excel file
- Press quot;Ctrl Vquot; (to paste the contents to this new Excel file)

Hope this helps.