Event Before refresh pivot cache

[Paul_Hossler]

Paul, I recently asked about the ability to monitor the built-in ribbon buttons. Here: http://www.vbaexpress.com/forum/showthread.php?65211

What if you went this way? Do you have something against?
Such a solution would require some work, but it would be natural for the user.
But, perhaps, the button on the sheet is enough.

Artik

(2) - That button was only to simulate some processing prior to refreshing the PT with some new data

I'd need to have a code immediately run after that, but before actual data "refresh".

Since I assume there will be a macro or something that updates the source data, I was just faking it with the button

The user really doesn't need to do anything since if the source data range changes, then the PT is refreshed

(1) - is just a manually initiated PT refresh, again faking some data changes and then the PT refresh


Personally I'd use (2) since I don't trust users to do the right (expected) thing and this way it should be transparent to them