Auto update of Pivot table

[K. Georgiadis]

C. Pearson's website includes VBA code for automatically
updating a Pivot table upon opening the worksheet. Does
the code need to be inserted in "This Workbook" or set up
as a Module?

 

[jeff]

Hi,

I believe it needs to be in a module and the calling
macro named "Auto_open"; (you can use "Auto_Close"
also to clean up if needed.)

jeff