I am confused :-?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: I am confused :-?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    CA
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default I am confused :-?

     


    I created a data validation range (list with a named range). That list is supposed to include an "in cell dropdown" but the dropdown does not show up.

    The ultimate problem is that when a change is made in the named range (inside the range) that change is not reflected and no choice is available for that new entry since a dropdown is not there.

    The range i creted the data validation for is about 14,000 rows by 1 column. I recreated the data validation on a smaller range and it still does not give me the in cell drop down.

    Does this make sense? Any thoughts?

    thanks in advance

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am confused :-?

    Quote Originally Posted by geolefty


    I created a data validation range (list with a named range). That list is supposed to include an "in cell dropdown" but the dropdown does not show up.

    The ultimate problem is that when a change is made in the named range (inside the range) that change is not reflected and no choice is available for that new entry since a dropdown is not there.

    The range i creted the data validation for is about 14,000 rows by 1 column. I recreated the data validation on a smaller range and it still does not give me the in cell drop down.

    Does this make sense? Any thoughts?

    thanks in advance
    Is the in cell drop down checked?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    CA
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    YES

    and to add to the strangeness, I copied out this problem column to another workbook and the drop down shows up perfectly fine.

    I just do not get it.

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about saving your file, exiting Excel, shutting down your computer, restarting it, and reopening the saved file in Excel -- let us see if that clears up the problem!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    CA
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I restarted and still no luck.

    I am able to copy out the column or just a handful of cells into a blank file and the drop down is fine.

    Although this gave me an idea. After a couple of attempts I was able to 'trick' excel.

    The column in question was AD. I tried to copy all the sheets from the original book into a new one and then delete column AD from the new file and then copy the OLD column AD and insert copied cells. That did not work.

    I then tried to copy a block of the data. NOPE. I then tried to extend the data validation to ALL of the cells (somehow it was in most but not all). STILL NO drop downs.

    I then copied the columns in blocks, columns A-AC, then AD, then the rest of the columns. BINGO that worked (for now).

    Something I forgot to mention was that the drop down DID appear early on in the history of this file.

    I guess I found a solution (possibly temporary) but would love it if omeone could tell me why it happened in the first place.

    thanks a bunch.

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you copy and paste into the cell that is validated, you lose everything.

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    CA
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i copied and pasted cells that were already validated but just not showing the drop down.

    when I copied out either the column or a smaller range of cells the dropdown appeared. When I tried to copy the whole sheet - it did not work

  8. #8
    Board Regular Egress1's Avatar
    Join Date
    Mar 2003
    Location
    Lubbock, Texas
    Posts
    420
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by geolefty
    i copied and pasted cells that were already validated but just not showing the drop down.

    when I copied out either the column or a smaller range of cells the dropdown appeared. When I tried to copy the whole sheet - it did not work
    By any chance was the column width or row height changed?

    Ken

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    CA
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am confused :-?

      
    still very confused

    No change in row height or column width. In fact on the sheets it works the row height and column width can be varied at will.

    So far I have figured out the following.

    It works when I...
    Copy entire column to another sheet in a new file.
    Copy portions of range to another sheet in a new file.
    Copy entire column to another sheet in the SAME file.
    Copy portions of range to another sheet in the SAME file.


    It DOES NOT work when I...
    Copy entire column into another column on the same SHEET.
    Copy portions of range to another part of the same SHEET.
    Copy directly over exsiting column and range
    Copy entire sheet to another workbook


    thanks for the input still trying.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com