Capture Excel Pivot Table Refresh event

Question

Is there an event corresponding to the data refresh of a pivot table? I have found the

    worksheet_pivottableupdate

event but this seems to be called everytime I change filters or manipulate the pivottable (which is quite frequently with my macros). What I need is just to capture when the underlying data is updated. Any way to do this?

what about using the worksheet_change event of the sheet where the source data is located? — Scott Holtzman
– Scott Holtzman, Commented Aug 21, 2012 at 15:45

Khorne · Accepted Answer · 2013-06-04 09:53:40Z

2

One way to tackle this is to use the pivottableupdate event, and combine it with checking that the following pivot-table property has changed.

PivotTables("PivotTable1").RefreshDate

See http://msdn.microsoft.com/en-us/library/ff834610(v=office.14).aspx for more information on the RefreshDate property.

answered Jun 4, 2013 at 9:53

Khorne

1661 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Capture Excel Pivot Table Refresh event

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related