In-cell dropdown arrow not appearing

Big Blue · Mar 25th, 2002, 10:45 AM

I have a complicated spreadhseet. I use data validating on some columns of user input, against a list I created on same sheet. It worked fine. I copied the worksheet into a new directory, and now the validation arrow and drop down list won't appear. Any ideas?

Tom Schreiner · Mar 25th, 2002, 11:24 AM

Hi

Just to not bypass the obvious.
Have you checked Data Validation, Settings, in cell dropdown?

Tom

Big Blue · Mar 25th, 2002, 11:26 AM

Thanks Tom, but yes I did.
I'm sure it must be related to copying the shhest toa new workbook and directory, although there aren't any external references.

IML · Mar 25th, 2002, 11:27 AM

Another thing to check would be:
Tools option view

make sure show all is checked under Objects.

Big Blue · Mar 25th, 2002, 11:30 AM

Did that too, but keep the ideas coming! I've overlooked something... :S

Barrie Davidson · Mar 25th, 2002, 11:34 AM

Do you have the "Freeze Pane" option on in the Window menu? I believe that you can't see the drop down arrow in the "frozen section".

Regards,

Big Blue · Mar 25th, 2002, 12:04 PM

Thanks Barrie, I'm not using freeze pane. You'r right that drop down won't work with freeze pane though.

still

Barrie Davidson · Mar 25th, 2002, 12:10 PM

Okay, I must apologize for not reading your posting correctly. Using a range for data validation lists will only work if the range is in the same sheet. However, you can use a defined name for validation. From the Excel's help:

Quote:

If the list of valid entries is in another worksheet or workbook, define a name for the external data on the active worksheet. In the Source box, you can then refer to the name on the same worksheet. For example, if the data you want to use in a formula is in cells A6:A12 on the first worksheet in a workbook named Budget.xls, you could define the name ValidData on the active worksheet to be =[Budget.xls]Sheet1!$A$6:$A$12 and then enter =ValidData in the Source box.

Regards,

Big Blue · Mar 25th, 2002, 12:16 PM

No need to apologize.. I appreciate the effort! I thought it might be becuase of using named range, so changed the validation to a list of values entered directly into the validation source box, but still no luck.

Some how I must have screwed up with the copying. The dropdown hust won't work. The data is validated (ie can't enter invalid data) but no dropdown list to choose from.

Barrie Davidson · Mar 25th, 2002, 12:24 PM

Quote:

On 2002-03-25 11:16, Big Blue wrote:
No need to apologize.. I appreciate the effort! I thought it might be becuase of using named range, so changed the validation to a list of values entered directly into the validation source box, but still no luck.

Some how I must have screwed up with the copying. The dropdown hust won't work. The data is validated (ie can't enter invalid data) but no dropdown list to choose from.

Have you got the "In-cell dropdown" box checked in the data validation message box?

Mar 25th, 2002, 11:34 AM	#6
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Do you have the "Freeze Pane" option on in the Window menu? I believe that you can't see the drop down arrow in the "frozen section". Regards, __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 10:45 AM	#1
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	I have a complicated spreadhseet. I use data validating on some columns of user input, against a list I created on same sheet. It worked fine. I copied the worksheet into a new directory, and now the validation arrow and drop down list won't appear. Any ideas?

Mar 25th, 2002, 11:24 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Just to not bypass the obvious. Have you checked Data Validation, Settings, in cell dropdown? Tom

Mar 25th, 2002, 11:26 AM	#3
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	Thanks Tom, but yes I did. I'm sure it must be related to copying the shhest toa new workbook and directory, although there aren't any external references.

Mar 25th, 2002, 11:27 AM	#4
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	Another thing to check would be: Tools option view make sure show all is checked under Objects.

Mar 25th, 2002, 11:30 AM	#5
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	Did that too, but keep the ideas coming! I've overlooked something... :S

Mar 25th, 2002, 12:04 PM	#7
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	Thanks Barrie, I'm not using freeze pane. You'r right that drop down won't work with freeze pane though. still

Mar 25th, 2002, 12:16 PM	#9
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	No need to apologize.. I appreciate the effort! I thought it might be becuase of using named range, so changed the validation to a list of values entered directly into the validation source box, but still no luck. Some how I must have screwed up with the copying. The dropdown hust won't work. The data is validated (ie can't enter invalid data) but no dropdown list to choose from.