Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Redditch, Worcestershire, England
    Thanked 22 Times in 21 Posts
    This is just a curiosity now since I cleared the problem by closing and restarting Excel, but yesterday I opened a workbook containing a lookup list and certain cells that use Data Validation pointing to the list to provide the user with a drop-down list of values for selection. I changed the bits I needed to and then clicked in one of the "validated" cells expecting to see a drop-down arrow but it did not appear! Checking other cells suggested that the validation setting had been lost everywhere!

    I put this down to an end-user error by someone using the file before me but then tried a couple of other workbooks which I knew had validation set - they exhibited the same problem.

    I couldn't think of a quick workaround, but closing and restarting Excel cleared the problem - if I reopened the files, the drop-down arrows were displayed!!

    Has anyone seen this happen before or know of a setting or combination of circumstances I should have checked?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    I don't think the validation really disappeared. It looks like the part of Excel that processes validation had come unstuck in memory - perhaps a bit fell over. By quitting and restarting Excel, this part was freshly loaded into memory again.

Posting Permissions

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