Operating System - Microsoft
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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 ...