| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Excel named ranges using MS Query
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. Please help. Kathy H |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Accessing named ranges in Excel from VBA | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
