Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Lost dropdowns (2000)

    Although I have set up dropdown lists in the validation options for some columns on one of my worksheets, lately all the dropdown arrows have disappeared, so I can't use the lists---what could be causing this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Lost dropdowns (2000)

    If the arrows have disappeared, it could be that the validation is deleted. To test if Validation is still on, select the entire spreadsheet and choose EDIT GOTO and click the SPECIAL button. Select validation cells and All and chose OK. This will or should highlight cells with validation. If no cells are highlighted, then there is no validation cells and your arrow validation has been deleted. You will need to set up the rules again!
    Regards,
    Rudi

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Lost dropdowns (2000)

    One thing to be aware of with datavalidation:
    If you copy a cell that has no datavalidation over a cell with datavalidation, the datavalidation will be "removed"

    Steve

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Lost dropdowns (2000)

    Thanks for your reply. The validation still works when an item is typed into a cell, it's just that the dropdown arrows don't appear (even though the 'in-cell dropdown' option is ticked), so items can't be selected from a list.

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Lost dropdowns (2000)

    Problem solved. It seems to have been caused by some corrupt links, as after I rebuilt the file by copying and pasting all the sheets into a new workbook (and removing the old filename from all links and defined names), the dropdowns are now working again.

  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost dropdowns (2000)

    I had a similar - though intermittent - problem with filters in xl2k when I first moved to it - I seem to recall that a service pack install fixed it but can't remember which one. (FWIW, I occaisionally get colleagues complaining of this in XP as well). If service packs don't work, try working through <!post=Jan Karel's starpost ,290455>Jan Karel's starpost <!/post> on behaviour problems and see whether that helps.

  7. #7
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost dropdowns (2000)

    Glad to hear it's fixed - even if my reply was of no help! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •