Auto update of Pivot table

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Update 3
Code to add gridlines to Excel Pivot Tables 0
Excel VBA For excel 0
Single Filter to change all Pivot Tables in a Workbook 8
slow document / pivot table refresh and pivot function 2
Excel Error while updating an external data source into a pivot table! 0
Pivot tables - Editing the data source shared by multiple pivot ta 1
Link Pivot Tables on one filter 2

Back
Top