Vba to refresh pivot table source data

[Alpacino]

Hi there I have multiple pivot tables in several sheets. Each pivot has different a dymanic source data (updates each week) is there a macro that wil refresh each pivot table in workbook??

Thanks

 

[Jerry Sullivan]

Hi there I have multiple pivot tables in several sheets. Each pivot has different a dymanic source data (updates each week) is there a macro that wil refresh each pivot table in workbook??

Thanks

Hi, This thread shows a few methods for doing that.

http://www.mrexcel.com/forum/showthread.php?t=571489#post2829263

 

[november]

Hi, This thread shows a few methods for doing that.

http://www.mrexcel.com/forum/showthread.php?t=571489#post2829263

He's looking to update the source data, not just refresh the pivot tables.