Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop list from a different workbook,
I followed instructions in www.contextures.com/xlData Val05.html and I get
the same error. You cannot use a range from another workbook - help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop list from a different workbook,
Have you read this
For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is always open, but hidden, such as the Personal.xls workbook. -- Regards Ron de Bruin http://www.rondebruin.nl "myquest" wrote in message ... I followed instructions in www.contextures.com/xlData Val05.html and I get the same error. You cannot use a range from another workbook - help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop list from a different workbook,
Yes, I tried creating a completely new workbook and keeping it open.
Same thing - I named the range with my list; I went to my first wrkbook and defined a name using the other workbk name and then the name. Then at Data - validation - source I put that name. I always get the same error. "Ron de Bruin" wrote: Have you read this For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is always open, but hidden, such as the Personal.xls workbook. -- Regards Ron de Bruin http://www.rondebruin.nl "myquest" wrote in message ... I followed instructions in www.contextures.com/xlData Val05.html and I get the same error. You cannot use a range from another workbook - help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop list from a different workbook,
Follow Debra's steps again and you will see that it is working
-- Regards Ron de Bruin http://www.rondebruin.nl "myquest" wrote in message ... Yes, I tried creating a completely new workbook and keeping it open. Same thing - I named the range with my list; I went to my first wrkbook and defined a name using the other workbk name and then the name. Then at Data - validation - source I put that name. I always get the same error. "Ron de Bruin" wrote: Have you read this For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is always open, but hidden, such as the Personal.xls workbook. -- Regards Ron de Bruin http://www.rondebruin.nl "myquest" wrote in message ... I followed instructions in www.contextures.com/xlData Val05.html and I get the same error. You cannot use a range from another workbook - help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop list from a different workbook,
You are quite right; If I use her exact range names and workbook name it
works but not with mine! I was using PartsBook.xls and the range name was PartList. Very strange but I must be making a silly mistake - more coffee. Thanks "Ron de Bruin" wrote: Follow Debra's steps again and you will see that it is working -- Regards Ron de Bruin http://www.rondebruin.nl "myquest" wrote in message ... Yes, I tried creating a completely new workbook and keeping it open. Same thing - I named the range with my list; I went to my first wrkbook and defined a name using the other workbk name and then the name. Then at Data - validation - source I put that name. I always get the same error. "Ron de Bruin" wrote: Have you read this For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is always open, but hidden, such as the Personal.xls workbook. -- Regards Ron de Bruin http://www.rondebruin.nl "myquest" wrote in message ... I followed instructions in www.contextures.com/xlData Val05.html and I get the same error. You cannot use a range from another workbook - help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
Combo box list w/ data in 2nd workbook without opening both files | Excel Worksheet Functions | |||
Problems with external references when creating a drop down list | Excel Discussion (Misc queries) | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) | |||
Drop down list question | New Users to Excel |