Event Before refresh pivot cache

[Artik]

The only other ways I know would be to 1) (...) 2 (...)

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