| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Tables referring to external data query
In my excel file I am querying external data(an ODBC database) in one sheet.
The query data amounts to over 10,000 rows. I am using a pivot table to summarize the query data. As my query data expands, the pivot table range doesn't expand. Is there a setting that enables the pivot table range to expands with the query data? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
| Help with Charting My Data -- | Charts and Charting in Excel | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| Help with pivot charts and data labels | Charts and Charting in Excel | |||
| How do I get a web query to auto-refresh before a pivot table aut. | Excel Discussion (Misc queries) | |||
Threaded Mode
