Excel 2007 does not preserve sheet protection

Giganews Newsgroups
Subject: Excel 2007 does not preserve sheet protection
Posted by:  Maximilian Taino
Date: Thu, 31 Jul 2008

I am experiencing problems with excel 2007. My users created various sheets
and protected some columns with password. This work was done with excel
2000/XP/2003. Sometimes they have to copy one sheet of these workbooks to a
new sheet, maintaining columns protection. With excel version previous to
Excel 2007 there was no problem. With this new version (and with SP1 applied)
column protecion gets lost during copy. Before copying the sheet is
protected, and you must enter password to unlock it. The new copy is
unprotected, even if I don't enter passwords before copying.

Any help would be appreciated.
Max

Replies