Linkback Tables in PowerPivot for Excel 2013
In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using the Linked Table feature. Excel 2013 expands this capability by introducing the option of extracting data from the PowerPivot data model to an Excel table, which you can then import into the PowerPivot data model again after applying some Excel calculation. We call this a linkback table. In this article, you will see how to use this interesting feature in Excel 2013.
Read more...