Pivot tables - new columns

  • Thread starter Thread starter SB Lee
  • Start date Start date
S

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.
 
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....................
 
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.
 
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.)
 
Excellent - that was easy. Thanks.

Dave Peterson said:
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.)
Click to expand...
 
Back
Top