Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to external workbook in Data Validation
I have 2 workbooks. In one (1), i want to use Data Validation to create a drop down menu. The other (2) workbook has a range of data. In (1), I defined a range so that it uses the data in (2). I named it book4, and it refers to: =[Book4.xls]Sheet1!$A$1:$B$4 . However, when i try to enter "=book4" into Source in Data validation i get the error: You may not use references to other workbooks or worksheets in Data Validation Criteria". But i clearly read that this is possible! -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=573743 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to external workbook in Data Validation
Check this out:
http://exceltips.vitalnews.com/Pages...alidation.html Dave -- Brevity is the soul of wit. "aposatsk" wrote: I have 2 workbooks. In one (1), i want to use Data Validation to create a drop down menu. The other (2) workbook has a range of data. In (1), I defined a range so that it uses the data in (2). I named it book4, and it refers to: =[Book4.xls]Sheet1!$A$1:$B$4 . However, when i try to enter "=book4" into Source in Data validation i get the error: You may not use references to other workbooks or worksheets in Data Validation Criteria". But i clearly read that this is possible! -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=573743 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to external workbook in Data Validation
I did this to fix the problem. Please tell me if this method is correct and fool-proof. Book 1 is where my validation is. Book 2 is where my data is. In book 2, i highlighted the data and defined it as 'report'. In Book 1, i made another Name (Define) which goes to Book2 and gets 'report'; i name this "City". Then in data validation, i can enter City and it works! -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=573743 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show do I share a dynamic list for data validation? | Excel Discussion (Misc queries) | |||
Excel use another Workbook for data validation range. | Excel Discussion (Misc queries) | |||
Data Validation in another Workbook - HELP! | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |