Pivot tables - new columns

[SB Lee]

When you create a pivot table and add new columns to the end of the source
data (just an excel document) how do you update the pivot to make those new
columns available to use? If I add new columns in the middle of the source
data and do refresh it works but if the columns are added to the end of the
data refresh does not work.

Thanks.

 

[Ken Wright]

When you insert columns within a PT source, Excel will automatically expand
the range, but if you add them to the outside, you have to change your data
source manually to include the new columns.

Or, an easier way is to use a Dynamic Data Source, eg:-

http://www.contextures.com/xlPivot01.html

Regards
Ken....................

 

[SB Lee]

Thank you - I will look at using a dynamic data source but if I were to
change the data source manually how do I actually do it? I can't find
anywhere in the pivot table where it gives you the option to change the data
source without creating a new pivot table. Thank you.

 

[Dave Peterson]

Rightclick on the pivottable and show the wizard.

Then use the back button to go as far back as you need to so you can specify the
new range. If you don't use the dynamic range that Ken suggested, write down
the address before you start the wizard. (It'll make it just a tad easier.)

 

[SB Lee]

Excellent - that was easy. Thanks.

Rightclick on the pivottable and show the wizard.

Then use the back button to go as far back as you need to so you can specify the
new range. If you don't use the dynamic range that Ken suggested, write down
the address before you start the wizard. (It'll make it just a tad easier.)

 

[Ashish Mathur]

Hi,

you may convert the pivot source data to a List - list auto expands when
data is added by rows/columns

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com