Pivot Refresh onClick

Is there a code that will refresh a pivot automatically when the sheet is clicked (where the pivot exists)?

you can use the worksheet activate event. Paste this code into the sheet module. Adjust the pivot table name, if required.

Please Login or Register  to view this content.