You need to right click in the Pivot Table and hit 'Refresh Table', can be
done automatically with code,
Regards
"wal50" wrote in message
...
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?