ExcelBanter - Dropdown list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Dropdown list (https://www.excelbanter.com/excel-worksheet-functions/192280-dropdown-list.html)

I have created a dropdown list in Windows NT, Excel 2002. The dropdown is in
multiple workbooks on a shared drive. The workbooks however, are not shared
workbooks. We are having a problem with all users being able to use the
dropdown.

The box/arrow is in each cell, but either the list doesn't appear or an
error message is received when clicking in any cell. How can we remedy this?

I entered a list in a single column and created a Name for the cells. From
Name, on the Insert menu, I chose Define. I typed the Name in 'Names in
workbook' box, deleted 'Refers to' contents and hi-lited the cells containing
the list. (For the other workbooks, I hi-lited the original workbook list).
I hi-lited the destination cells. From the Data menu, I chose Validation,
chose Settings. In the Allow box I chose List. In the Source box, I typed
the list Name, preceded by = sign. For Style, I selected Information (to
allow other data to be entered).

When I open any of the worksheets, I see the dropdowns and everything works
fine. But, when other users click on the dropdown, it's either blank or the
error alert message "Invalid dated is entered".

Nita Carmicle
Cleveland, OH

"RagDyeR" wrote:

What method did you use to create the list, and what is the error message?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nita Carmicle" <Nita wrote in message
...
I have created a dropdown list in Windows NT, Excel 2002. The dropdown is
in
multiple workbooks on a shared drive. The workbooks however, are not shared
workbooks. We are having a problem with all users being able to use the
dropdown.

The box/arrow is in each cell, but either the list doesn't appear or an
error message is received when clicking in any cell. How can we remedy
this?

Check out this web page of Debra Dalgleish:

http://www.contextures.com/xlDataVal05.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Nita Carmicle" wrote in message
...
I entered a list in a single column and created a Name for the cells. From
Name, on the Insert menu, I chose Define. I typed the Name in 'Names in
workbook' box, deleted 'Refers to' contents and hi-lited the cells
containing
the list. (For the other workbooks, I hi-lited the original workbook list).
I hi-lited the destination cells. From the Data menu, I chose Validation,
chose Settings. In the Allow box I chose List. In the Source box, I typed
the list Name, preceded by = sign. For Style, I selected Information (to
allow other data to be entered).

When I open any of the worksheets, I see the dropdowns and everything works
fine. But, when other users click on the dropdown, it's either blank or the
error alert message "Invalid dated is entered".

Nita Carmicle
Cleveland, OH

"RagDyeR" wrote:

What method did you use to create the list, and what is the error message?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nita Carmicle" <Nita wrote in message
...
I have created a dropdown list in Windows NT, Excel 2002. The dropdown is
in
multiple workbooks on a shared drive. The workbooks however, are not
shared
workbooks. We are having a problem with all users being able to use the
dropdown.

The box/arrow is in each cell, but either the list doesn't appear or an
error message is received when clicking in any cell. How can we remedy
this?

Thank You!

Found the answer on the site you sent. The source workbook must be open for
the other workbooks to perform.

To elimimate the problem, I had to set up each file independently. and the
worksheets within the files are now working. The error message 'Invalid data
entered' was fixed by changing the Validation Style to 'Information'. It was
previously set as 'Stop' disallowing any type of entry other than the list.

Yoou've been a great help!!!!!!

--
Nita Carmicle
Cleveland, OH

"RagDyeR" wrote:

Check out this web page of Debra Dalgleish:

http://www.contextures.com/xlDataVal05.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Nita Carmicle" wrote in message
...
I entered a list in a single column and created a Name for the cells. From
Name, on the Insert menu, I chose Define. I typed the Name in 'Names in
workbook' box, deleted 'Refers to' contents and hi-lited the cells
containing
the list. (For the other workbooks, I hi-lited the original workbook list).
I hi-lited the destination cells. From the Data menu, I chose Validation,
chose Settings. In the Allow box I chose List. In the Source box, I typed
the list Name, preceded by = sign. For Style, I selected Information (to
allow other data to be entered).

When I open any of the worksheets, I see the dropdowns and everything works
fine. But, when other users click on the dropdown, it's either blank or the
error alert message "Invalid dated is entered".

Nita Carmicle
Cleveland, OH

"RagDyeR" wrote:

What method did you use to create the list, and what is the error message?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nita Carmicle" <Nita wrote in message
...
I have created a dropdown list in Windows NT, Excel 2002. The dropdown is
in
multiple workbooks on a shared drive. The workbooks however, are not
shared
workbooks. We are having a problem with all users being able to use the
dropdown.

The box/arrow is in each cell, but either the list doesn't appear or an
error message is received when clicking in any cell. How can we remedy
this?

Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nita Carmicle" wrote in message
...
Thank You!

Found the answer on the site you sent. The source workbook must be open for
the other workbooks to perform.

To elimimate the problem, I had to set up each file independently. and the
worksheets within the files are now working. The error message 'Invalid
data
entered' was fixed by changing the Validation Style to 'Information'. It
was
previously set as 'Stop' disallowing any type of entry other than the list.

Yoou've been a great help!!!!!!

--
Nita Carmicle
Cleveland, OH

"RagDyeR" wrote:

Check out this web page of Debra Dalgleish:

http://www.contextures.com/xlDataVal05.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Nita Carmicle" wrote in message
...
I entered a list in a single column and created a Name for the cells.
From
Name, on the Insert menu, I chose Define. I typed the Name in 'Names in
workbook' box, deleted 'Refers to' contents and hi-lited the cells
containing
the list. (For the other workbooks, I hi-lited the original workbook
list).
I hi-lited the destination cells. From the Data menu, I chose Validation,
chose Settings. In the Allow box I chose List. In the Source box, I
typed
the list Name, preceded by = sign. For Style, I selected Information (to
allow other data to be entered).

When I open any of the worksheets, I see the dropdowns and everything
works
fine. But, when other users click on the dropdown, it's either blank or
the
error alert message "Invalid dated is entered".

Nita Carmicle
Cleveland, OH

"RagDyeR" wrote:

What method did you use to create the list, and what is the error
message?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nita Carmicle" <Nita wrote in
message
...
I have created a dropdown list in Windows NT, Excel 2002. The dropdown
is
in
multiple workbooks on a shared drive. The workbooks however, are not
shared
workbooks. We are having a problem with all users being able to use the
dropdown.

The box/arrow is in each cell, but either the list doesn't appear or an
error message is received when clicking in any cell. How can we remedy
this?