Menu
What is the difference between refreshing a pivot table and refreshing the underlying pivot cache?
In other words, is there a difference between
PivotTable.PivotCache.Refresh
PivotTable.RefreshTable
855
Clear a PivotChart Click the PivotChart. On the Analyze tab, in the Data group, click Clear, and then click Clear All. The Clear All command resets your PivotTable, but does not delete it. The data connection, placement of the PivotTable, and PivotTable cache remain the same.
While a Normal Excel Table is a mere representation of facts and figures fed by you, a pivot table summarizes the data which include different type of aggregation like average, sum, count, and so on as well. You can also apply different filters in Pivot Table that can help you perform data analysis.
The normal pivot version just lists fields within this single table or source that we're pointing to. Power Pivot allows us to access any of the fields in any of the tables in our data model, and then analyze them based on any relationships that we've defined. So that's the most obvious of the differences.
A PivotCache object can support many PivotTables so refreshing the former refreshes all its supported tables.
Refreshing a PivotTable supported by a particular PivotCache object does not refresh all the other PivotTable objects that hang off it.
196
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
