"Jon Peltier" wrote in message
...
Not everything can be read from a closed workbook that can be read from an
open one. could you put a copy of the data from the one workbook into the
other and redefine the name in the second workbook?

That's really interesting. Yes, I'll replicate the named range and data in
the 2nd spreadsheet.

Thanks,

V