Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TWilson
 
Posts: n/a
Default Cells User Select Locked after upgrade to Excel 2002


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

  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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" wrote in
message ...
|
| 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
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
All Cells in Excel are locked, what's wrong? Samuel Excel Discussion (Misc queries) 6 July 18th 05 12:31 AM
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? Daniel Excel Worksheet Functions 6 July 11th 05 11:24 PM
Viewing LOCKED cells AC_VID Excel Discussion (Misc queries) 1 April 9th 05 11:19 PM
Excel user management CTE Excel Discussion (Misc queries) 1 February 22nd 05 01:12 PM
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 07:31 AM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"