Power Pivot Question - Adding a column from the Source Table

D

Dave K

Hello - I am using a PowerPivot file that is linked to a single Excel
file. I needed to add a column to the Source Excel File, and now am
hoping to simply pull the new column from the Source Table into my
PowerPivot table (i.e., hopefully in the same PowerPivot tab that I am
already using).

Is there a straightforward way to accomplish this?

I tried to simply refresh my source in PowerPivot, but that did not
work. Then I tried to repull the source file, but that simply added a
second tab to my PowerPivot file with all of the same data repeated.

Thanks for any suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 Slicer Connection / Pivot Table Problem 3
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Pivot table report invalid 0
Turning Data into a Table 1
Export Pivot table 1
Pivot source error 1
Pivot Table data source 1

Top