you can use external data source and then there is no need to load the query table to the sheet, only once you get the pivot table