Data Validation Restriction Referencing other Workbook
Following procedure to link Data Validation list to another workbook -
dialogue box message appears "You may not use references to other worksheets or workbooks for data validation criteria". I am using Excel 2003. Any suggestions are greatly welcomed! Jim |
Data Validation Restriction Referencing other Workbook
Give your list a name, select the list and do insertnamedefine and type in
a name for instance MyList then use Allowlist =MyList -- Regards, Peo Sjoblom "Jim" wrote in message ... Following procedure to link Data Validation list to another workbook - dialogue box message appears "You may not use references to other worksheets or workbooks for data validation criteria". I am using Excel 2003. Any suggestions are greatly welcomed! Jim |
All times are GMT +1. The time now is 02:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com