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?