SQL query a workbook - too many named ranges?
 

I'm trying to SQL query a workbook using "data" - "import data"...

I've done this a million tomes in the past but have come up against a
peculiar issue. I generally query named ranges. But, if there are too
many named ranges in the workbook, the SQL engine can't find the named
range (cannot find object "mynamedrange"). If the source WB is open,
the SQL engine "see's" the named range, but if the source WB is closed,
the query fails. Any ideas?


Thanks, Dave