Refresh Pivot Table Automatically

A

anandmr65

Hi,

I have some 8 pivot table that looks at one data table. This data tabl
needs to be updated manually very frequently. Now every time this dat
table changes, all the pivot table need to be refreshed automatically
If I use the refresh on open option, then the workbook need to b
closed & opened.

Is there a way where the pivot table gets refreshed as and when th
data changes in data table.

Please let me know.

Thanks & Regards
Anan
 
M

Mallycat

You could set the on_change event for the worksheet with the data tabl
on it to refresh the pivot tables. If you make pivot tables 2-8 linke
to the original pivot table, then you only have to refresh one for the
all to work

Mat
 

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 and chart refresh not an option 1
Pivot Table Refresh not working properly 1
How do I save Pivot Table Data 4
Pivot table 1
Automatically Refresh pivot table 6
Pivot Table - Changes 5
Pivot Table Refresh? 1
Pivot Table update 8

Top