Add columns to data source (sheet within workbook)

[bkuhlmann]

Hi Everyone,

Here's a scenario:

I have a spreadsheet of data which I select then click "Insert Pivot Table" and check off the box "Add to Data Model". The result is that I have a new sheet with a pivot table, and a sheet with the source data.

I need to add new columns to the source data, so I add them on the right, then go to the pivot table and click "Change Data Source" then select the full table including the new columns. Unfortunately, this creates an entirely new data source in the data model, rather than just editing the original data source.

I've also tried to modify the data source other other ways to no avail. Can anyone tell me how to add columns to a data source that is a sheet within the excel workbook?

Thanks!

Ben

 

[nikio8]

Hi,
If your source data is a table, Ctrl+T, you would just need to refresh your pivot table and voila, columns are available to add to pivot table.
Otherwise, perhaps change your range in Formaulas - Name Manager.