Arvi Laanemets wrote:

You must define your source table as non-dynamic named range

Or in the table options, check 'system tables' and the worksheet names
will be available. Or just type the SQL in, using the sheet name or
range address e.g.

SELECT MyCol FROM [Sheet1$];

Jamie.

--