Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL97: Error When Using Validation Drop-Down List Box
Article ID: 157484 - View products that this article applies to.
This article was previously published under Q157484
In Microsoft Excel 97, when you select a value in a validation drop-down list box, you may receive the following error message:
and you are unable to select a value in the list.
The cell or chart you are trying to change is protected and therefore read-only.
This will occur if all of the following conditions are true:
There are two possible workarounds for this problem: you can either unlock the cell that contains the validation drop-down list box, or you can set the validation drop-down list so that it refers to a range of cells, rather than directly containing its own values.
Method 1: Unlock the Cell Containing the Drop-Down List Box
Method 2: Make Your Drop-Down List Box Refer to a Range of CellsWhen you create a validation drop-down list box, you can either input a list of values:
One, Two, Three, FourOr, you can set the list box to refer to a range of cells for its values:
A1: OneValidation drop-down list boxes created using this second method do not experience any problems when used on a protected worksheet.
To create a validation drop-down list box that refers to a range of cells for its values, follow these steps:
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
Microsoft Excel 97 includes a new feature called validation. You can use validation to make sure that users only enter specific values, or specific types of values, into cells in Microsoft Excel.
One validation option allows you to attach a drop-down list box to a cell when the cell is selected. If you use this option, users can only enter values in the cell that are contained within the list box. The list box can obtain its values from two different sources: the list box can refer to a range of cells for its values, or it can contain them directly.
To create a validation drop-down list box that directly contains its own values, follow these steps:
For more information about validation drop-down list boxes in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text
data validation, drop-downand click Display to go to the "Specify the valid entries for cells" help topic.
Article ID: 157484 - Last Review: October 22, 2000 - Revision: 1.0