You also have to create a named reference to that external range in the
workbook that contains the data validation list. Then, use the new name as the data validation source. There are instructions he http://www.contextures.com/xlDataVal05.html Cezar DUMITRIU wrote: I have tried to create a drop-down list in Excel, with references in another workbook than the one where I wanted to input the data from the list, using the Data Validation function. Reading the Excel help, I've learned that in order to do that I have o define a Name (Insert--Name--Define) for the list in my reference workbook and when validating the data in my destination workbook, in the Data Validation dialog window, on the Settings tab, in the Source Box, I have to insert (preceded by an = sign) the Name defined previously. Unfortunately, although I followed all the steps as described in the Help item, I keep on getting the following Error Message: "You may not use references to other worksheets or wokbooks for Data Validation criteria." and I cannot validate the data. Can anybody help me with this? Please write to -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 01:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com