Re: unlocked cells in excel 2000 now locked when opened in 2003 why?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Are you sure those cells are unlocked in xl2k?

xl2003 is more stringent than xl2k. You could use data|validation in a locked
cell in a protected *** in xl2k. xl2003 won't let you.

Debra Dalgleish posted this:

In Excel 2000 and earlier versions, you can change the selection in a
data validation dropdown, if the list is from a range on the work***.

If the list is typed in the data validation dialog box, the selection
can't be changed.

In Excel 2002 and later versions, neither type of dropdown list can be
changed if the cell is locked and the *** is protected.

This MSKB article has information on the previous behaviour:

XL97: Error When Using Validation Drop-Down List Box
http://support.microsoft.com/default.aspx?id=157484



GallanH wrote:
>
> An existing excel *** prepared in excel 2000 is password protected, users
> allowed to select entries from validated lists in unlocked cells. Users with
> excel 2003 can see the validated lists but if they try to select an item,
> they are told that the *** is protected and data cannot be entered. Looking
> at the settings, the unlocked cells in 2000 are now shown as locked in 2003.
> Is there a work round?

--

Dave Peterson
.

Quantcast