Adding new fields automatically into a pivot table

[llnivy]

Hi
I have a table that has new columns added often. Is there a way to have the new column automatically updated to the pivot table?
Thanks or the help.
Laurie

 

[fhqwgads]

what does the source data range of your pivot table look like?

if it's just a box like 'Sheet1'!$A$1:$H$11 maybe change it to the whole rows so it looks like 'Sheet1'!$1:$11
that should get any new columns in the source data added to the pivot table when you refresh data, though you still need to manually press the refresh data button