Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2006

Tip: Looking for answers? Try searching our database.

validation list became not working.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Miri - 31 Dec 2006 15:43 GMT
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....

Signature

Miri Tz.

Bob Phillips - 31 Dec 2006 16:10 GMT
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?

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> hi,
> i have an excel with lot of validation lists in severals sheets.
[quoted text clipped - 5 lines]
>
> thanks in advance....
Miri - 31 Dec 2006 16:32 GMT
yes. the arrow was lost. entering invalid value throwing an error.
Signature

Miri Tz.

> 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?
[quoted text clipped - 8 lines]
> >
> > thanks in advance....
Bob Phillips - 31 Dec 2006 17:03 GMT
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.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> yes. the arrow was lost. entering invalid value throwing an error.
>
[quoted text clipped - 13 lines]
>> >
>> > thanks in advance....
Dave Peterson - 31 Dec 2006 17:12 GMT
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.

> yes. the arrow was lost. entering invalid value throwing an error.
> --
[quoted text clipped - 23 lines]
> > > --
> > > Miri Tz.

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.