Analytics in Action

PowerPivot in Excel 2010. How to refresh data.

Excel 2010 Powerpivots are great tool to report on and slice and dice data.  Often underlying data sources changes and the Powerpivots need updating.  An example might be customer segmentation changing. A data refresh is used when now new columns of data are added- if new columns are added you need a data update. In this video I demonstrate how refresh an Excel 2010 Powerpivot. This is a two step process – first refreshing the Powerpivot table and then the actual pivottable or  chart.


admin

One Response to “PowerPivot in Excel 2010. How to refresh data.”

  1. […] this post I demonstrate how to update data in Powerpivots. Updates are different from a data refresh as updates incorporate new columns of data- so the structure of the underlying excel table changes. […]