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.