Operating System - Microsoft
1748063 Members
5676 Online
108758 Solutions
New Discussion юеВ

copying protected excel workbook

 
SOLVED
Go to solution
Georg Tresselt
Honored Contributor

copying protected excel workbook

Hi all,

Probably a stupid question: I have a protected (i.e. shared) workbook which I would like to create a copy of for another purpose. But every time I copy it the copy is considered shared and therefore protected. I cannot remove protection via Tools->Protection because I don't know the password.

Does anyone know a workaround?

Thanx alot

Georg
http://www.tresselt.eu
3 REPLIES 3
Frederic Zeller
Honored Contributor
Solution

Re: copying protected excel workbook

Hi Georg

If you can open it ( read-only ) you could try :

Either the save as ...

or if it doesn't work, the good old

Select-all , copy

And then paste in a new workbook !

HTH

Fred
Why should I bother ? The problem will be gone with the next release ...
Georg Tresselt
Honored Contributor

Re: copying protected excel workbook

I tried the Save As ... It didn't work. But Copy&Paste does the job.
http://www.tresselt.eu
Frederic Zeller
Honored Contributor

Re: copying protected excel workbook

Great !

Sometimes we just don't try the most obvious !

Fred
Why should I bother ? The problem will be gone with the next release ...