Pivot Table: Direct Data Loading
In VBA you can query a database and directly load result set to the Pivot Table “cache”. This allows for quick data refreshing since you bypass writing the data to excel and then refreshing the pivot tables.
3
votes
