Pivot Table - Updates

[Guest]

I create a Pivot table and it work fine. If I update any of the source data,
the table result does not change. Do I have an incorrect Option or is this
just the way Pivot tables work?

 

[Alan]

You need to right click in the Pivot Table and hit 'Refresh Table', can be
done automatically with code,
Regards

 

[Guest]

Thanks

You need to right click in the Pivot Table and hit 'Refresh Table', can be
done automatically with code,
Regards