Good afternoon,
Im looking for a piece of code that will automatically refresh a pivot table as soon as a data source is refresh without the need to manually refresh the pivot. The data source will automatically refresh after 30 minutes and both data source and pivot table are on the same worksheet. As soon as the refresh takes place I would like the pivot to automatically update.
Thanks in advance
DJ
Bookmarks