Run VBA before User triggered Pivottable Refresh

PearlGI

Registered User.
Local time
Today, 07:47
Joined
Aug 30, 2001
Messages
125
Is there a way to detect if a user has chosen to refresh a pivottable?

Ideally looking for something like a Before_Refresh Event.

Trying to get some VBA to modify the connection string before the pivottable refreshes the data.

[I don't need to know how to refresh a pivottable using a VBA.]


PLEASE: If you can't help, please don't reply to this thread saying you don't know - it doesn't help! :banghead:
 

Users who are viewing this thread

Back
Top Bottom