| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation between open Workbooks
I have a several lists in WorkbookA that is has a name range assign to each
list. WorkbookB is the workbook where the data validation is applied. WorkbookA is kept opened as well. But I get one of two errors when tring to apply data validation: 1. The Source currently evaluates to an error. 2. A Named range you specified can not be found. Can anybody give me some insite as to why I'm getting these two type of errors. Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation between open Workbooks
In the destination workbook, create a name that refers to the list in
the source workbook. There are instructions he http://www.contextures.com/xlDataVal05.html caldog wrote: I have a several lists in WorkbookA that is has a name range assign to each list. WorkbookB is the workbook where the data validation is applied. WorkbookA is kept opened as well. But I get one of two errors when tring to apply data validation: 1. The Source currently evaluates to an error. 2. A Named range you specified can not be found. Can anybody give me some insite as to why I'm getting these two type of errors. Steve -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation between workbooks | Excel Discussion (Misc queries) | |||
| dynamic link to external workbooks through data validation | Excel Discussion (Misc queries) | |||
| Data Validation over 2 workbooks? | New Users to Excel | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Hybrid Mode
