Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown list
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown list
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown list
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown list
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown list
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown list
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
Dropdown List within a dropdown | Excel Worksheet Functions | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions |