Getting PowerPivot columns back into the tables in Excel worksheets?

[xlpower]

If I add a calculated column to a table with PowerPivot, and the table in PowerPivot is linked to its counterpart in an Excel worksheet, how can I show the PowerPivot-calculated columns in the table in the Excel worksheet? I understand that Power Query has the capability to do this, but I do not yet understand how. Thank you.

 

[Matt Allington]

You can do it, but you have to add a second copy of the table back into Excel. That will give you 3 copies. 2 uncompressed copie sin Excel and 1 compressed copy in Power Pivot. Go to a new sheet in Excel, then select Existing connections, an dem pick the table from This workbook data model