validation list became not working.

[Guest]

hi,
i have an excel with lot of validation lists in severals sheets.
while working with the excel i all the validation list in specific sheet
became not working.the list are still defined in other sheet. but there is no
option to select from the list...
please help!

thanks in advance....

 

[Bob Phillips]

Do you mean that you have lost the drop-down arrow when you select the cell?
If so, does typing an invalid value in still throw an error?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

yes. the arrow was lost. entering invalid value throwing an error.

 

[Bob Phillips]

Okay, then try this.

Close the workbook (save if necessary).

Then goto File>Open and navigate the file browser to that file (don't select
it from the recent files).

Select the file from the available spreadsheets, don't click Open, but click
the drop-down arrow next to Open and select the Open and Repair option.

This will open it and repair it, fixing the lost validation. You will need
to do a saveas on the file, over the top of the previous file if you want,
as the repaired file is treated as a new file.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Dave Peterson]

One more guess...

Do you use xl97 and have you used window|Freeze panes?

And are your data|validation cells above that freeze panes line?

If yes, then there's a bug in xl97 and you'll have to remove the window|freeze
panes.