Cells User Select Locked after upgrade to Excel 2002

[TWilson]

We have several Excel spreadsheets that were created and protected in Excel 97 and 2000. Many of the wks are forms used by personnel for submitting expense reports, planning travel, etc. Recently we migrated all of our users to Office XP (Excel 2002).

Now when a user opens one of the spreadsheets created and protected in Excel 97/2000 in Excel 2002, enters data and then saves and closes it, when they re-open it all of the previously selected cells are un-selectable by the user.

If the user just opens one of the wks and does not make any changes and then saves it, when they reopen it the cells are not user select locked. The cells are only user select locking after data is entered and the file is saved.

Once the cells are user select locked, if the user takes the file back to a system still running office 2000 and opens it, the user can select and edit the cells contents.

Also if we open the cell select locked file in 2002 and save it as a Excel 95 file and then reopen it in 2002, the users is then once again able to enter data.

We fixed some of the wks by un-protecting them and then resetting the protections. However, this is not an option for all of the files as we do not control them.

We understand that Excel 2002 provides the developer with much more granularity in the protection options than previous versions. However, one would think that as cell user select locking was not an option in the earlier versions, Excel 2002 would not be enable this by default when working with a protected XLS file created in a previous version.

Does any by have an explanation and hopefully a solution for this does not require us to rework all of the files?

Thanks

[Jim Rech]

Most strange!. I've never heard or seen such a thing and I go between Excel
versions all the time. I do not have an explanation. If you sent me an
example workbook (with instructions) I'd like to try to reproduce the
problem. Does the workbook have macros? It they are disabled does the
problem occur?

--
Jim
"TWilson" <[email protected]> wrote in
message news:[email protected]...
|
| We have several Excel spreadsheets that were created and protected in
| Excel 97 and 2000. Many of the wks are forms used by personnel for
| submitting expense reports, planning travel, etc. Recently we migrated
| all of our users to Office XP (Excel 2002).
|
| Now when a user opens one of the spreadsheets created and protected in
| Excel 97/2000 in Excel 2002, enters data and then saves and closes it,
| when they re-open it all of the previously selected cells are
| un-selectable by the user.
|
| If the user just opens one of the wks and does not make any changes and
| then saves it, when they reopen it the cells are not user select locked.
| The cells are only user select locking after data is entered and the
| file is saved.
|
| Once the cells are user select locked, if the user takes the file back
| to a system still running office 2000 and opens it, the user can select
| and edit the cells contents.
|
| Also if we open the cell select locked file in 2002 and save it as a
| Excel 95 file and then reopen it in 2002, the users is then once again
| able to enter data.
|
| We fixed some of the wks by un-protecting them and then resetting the
| protections. However, this is not an option for all of the files as we
| do not control them.
|
| We understand that Excel 2002 provides the developer with much more
| granularity in the protection options than previous versions. However,
| one would think that as cell user select locking was not an option in
| the earlier versions, Excel 2002 would not be enable this by default
| when working with a protected XLS file created in a previous version.
|
|
| Does any by have an explanation and hopefully a solution for this does
| not require us to rework all of the files?
|
| Thanks
|
|
| --
| TWilson
| ------------------------------------------------------------------------
| TWilson's Profile:
http://www.excelforum.com/member.php...o&userid=25939
| View this thread: http://www.excelforum.com/showthread...hreadid=393164
|