Data validation on external workbook

Topics: Developer Forum, Project Management Forum, User Forum
Oct 5, 2012 at 10:58 AM

I have an excel that contains a data validation constraint based on a list of values taken from an external workbook (dati.xls) and in particular a named range (prodotti). The data validation is written as "=dati.xls!prodotti". Whenever I try to load this file I get the exception "unrecognized token 00 in formula". I would like to know if there is a way to get the cell value selected from the named range. If the named range is in a sheet of the same workbook everything is fine, but this is not suitable for me.

Please help me.