Change PivotTable Source from Worksheet Table to Power Pivot Table

**dinsyp** · 04-07-2022, 06:27 PM

Hi people,

Probably something simple but I want to change my PivotTable source from a named table to a Power Pivot table. So far I seem to be only able to do this by recreating the PivotTable from scratch. Is the a way of doing this from within the PivotTable?

Andrew

**XOR LX** · 04-08-2022, 12:28 AM

Hi,

You'll still need to have a new Pivot Table, but you won't need to recreate it from scratch if you click on the More Tables option at the bottom of the Pivot Table Fields list.

Regards

**dinsyp** · 04-10-2022, 04:58 PM

Thanks XOR LX. Most appreciated.

Change PivotTable Source from Worksheet Table to Power Pivot Table

LinkBack

Thread Tools

Rate This Thread

Display

Change PivotTable Source from Worksheet Table to Power Pivot Table

Re: Change PivotTable Source from Worksheet Table to Power Pivot Table

Re: Change PivotTable Source from Worksheet Table to Power Pivot Table

Thread Information

Users Browsing this Thread

Similar Threads

Refresh PivotTable and source Table (table source from Query itself)

How to create dynamic source for a pivot table from a append table in power query

Excel Power Query- The headers from the CSV source table can change.

[SOLVED] Refresh data source (excel table) in power pivot

Pivot table - change data source to another pivot table in 2010

Excel 2007 : How to change excel 2007 pivot table data source to another pivot table?

How to change data source of Excel 2007 pivot table to another pivot table?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions