Importing Excel named ranges using MS Query

[Guest]

I want to use multiple ranges (named) as the data source for a pivot table
using MS Query. When I import the workbook my options are only to select the
"tables" (which are my sheets referenced as sheetname$). I don't want to use
the entire sheet, just my named ranges in multiple sheets.

Thanks,
Kathy H

 

[Debra Dalgleish]

Names ranges should appear in the list of tables, unless they're dynamic
ranges. But if there's nothing else on the sheet, you can use the
sheetname$ tables.

 

[Guest]

They are dynamic. Now what

Names ranges should appear in the list of tables, unless they're dynamic
ranges. But if there's nothing else on the sheet, you can use the
sheetname$ tables.

 

[Debra Dalgleish]

Can you name the ranges programmatically, as the size changes, instead
of using a dynamic formula?