Hi. Is there a way to set up a pivot table so it will automatically
update when its source data changes. It seems that by default, I need
to explicitly tell it to refresh.

Thanks!

Ken