Excel 2007 does not preserve sheet protection

[Maximilian Taino]

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

 

[Jim Rech]

Although you didn't provide exact instructions to repro the problem I tried
a couple things with no luck. One was to protect a sheet and copy it to
another workbook. The sheet was still protected there. Then I use the
"Allow users to Edit Ranges" feature that assigns a password to a range but
I found that that too survived a copy to another workbook.

Can you provide the exact steps that you've tested that reproduce the
problem?

--
Jim
message |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