Excel 2007 does not preserve sheet protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maximilian Taino - 31 Jul 2008 09:01 GMT

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

Reply to this Message

Jim Rech - 31 Jul 2008 14:22 GMT

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?

Signature

Jim

|I am experiencing problems with excel 2007. My users created various sheets
| and protected some columns with password. This work was done with excel
[quoted text clipped - 7 lines]
| Any help would be appreciated.
| Max

Reply to this Message