Home » Forums » Open Source Learning Center » Question and Answer

How to figure out a pivot table needs to be refreshed in VBA?

Submitted by Amin Sanati on 2 December, 2013 - 08:50

Hi

I have a pivot table in a sheet. When the sheet is activated, I refresh it.
As refreshing takes time, I like to refresh it only when the source data has been changed. How can I figure out it in VBA?

Thanks,

Amin

‹ Need Excel Macro to compare Values of Two column based on Combo box selection value in Userform1 Search for date and then apply various search criterias ›
»