I am confused :-? :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

I am confused :-?
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

geolefty
Board Master


Joined: 07 Mar 2002
Posts: 127
Location: CA
Flag: Usa

Status: Offline

 Reply with quote  

I am confused :-?

icon_confused.gif

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

Post Fri May 02, 2003 9:22 pm 
 View user's profile Send private message

Brian from Maui
Board Master
Board Master


Joined: 17 Feb 2002
Posts: 2472

Flag: Blank

Status: Offline

 Reply with quote  

Re: I am confused :-?

quote:
Originally posted by geolefty:
icon_confused.gif

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?

Post Fri May 02, 2003 9:26 pm 
 View user's profile Send private message

geolefty
Board Master


Joined: 07 Mar 2002
Posts: 127
Location: CA
Flag: Usa

Status: Offline

 Reply with quote  

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.

Post Fri May 02, 2003 11:36 pm 
 View user's profile Send private message

Yogi Anand
MrExcel MVP


Joined: 13 Mar 2002
Posts: 5683
Location: Michigan USA

Status: Offline

 Reply with quote  

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

Post Fri May 02, 2003 11:54 pm 
 View user's profile Send private message

geolefty
Board Master


Joined: 07 Mar 2002
Posts: 127
Location: CA
Flag: Usa

Status: Offline

 Reply with quote  

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.

Post Sat May 03, 2003 12:57 am 
 View user's profile Send private message

Brian from Maui
Board Master
Board Master


Joined: 17 Feb 2002
Posts: 2472

Flag: Blank

Status: Offline

 Reply with quote  

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

Post Sat May 03, 2003 1:59 am 
 View user's profile Send private message

geolefty
Board Master


Joined: 07 Mar 2002
Posts: 127
Location: CA
Flag: Usa

Status: Offline

 Reply with quote  

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

Post Sat May 03, 2003 5:26 am 
 View user's profile Send private message

Egress1
Board Master


Joined: 02 Mar 2003
Posts: 288
Location: Lubbock, Texas
Flag: Usa

Status: Offline

 Reply with quote  

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

Post Sat May 03, 2003 6:42 pm 
 View user's profile Send private message Send e-mail

geolefty
Board Master


Joined: 07 Mar 2002
Posts: 127
Location: CA
Flag: Usa

Status: Offline

 Reply with quote  

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.

Post Mon May 05, 2003 5:15 pm 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.