Why use code? Pivot tables have an option to refresh on open under the table
options if I recall correctly.
--
HTH...

Jim Thomlinson


"JR" wrote:

Hello,

Can someone provide the code I can use to automatically update my pivot
tables upon opening the workbook.

Thanks