Event "BeforeRefresh" for PivotTable

Good day!

The goal is to calculate the duration of updating process*of PivotTable. PivotTable can be updated by the button (Refresh) or by simple manipulation (tuning filters, for example). To get the time during which the PivotTable is being updated, you need to know the start time and the end time of the update. When updating is finished the event Worksheet_PivotTableUpdate is raised. But for beginning of the update there is no such events, like BeforeRefresh for QueryTable.

Question: how to define the start of the updating process of*PivotTable?

Excel 2007/2010, pivottable based on external sources (PivotCache.OLEDBConnection).

I would be grateful for any idea! And even for the words - "you can not do that!"

I have a lot of Excel files with PivotTables inside. And i want to know how much time users spend for refresh each table. In fact any change of PivotTable structure (filtering,sorting,changing fields position) causing PivotCache refresh.

In case of MSOLAP connection, Excel throw MDX query to SSAS on any change of filters. In status bar we will see 'running OLAP query (press Esc to cancel)'

You are mistaken. When you change some filter:
1. Excel throw MDX query to SSAS (SQL Profiler, in StatusBar you can see 'running OLAP query (press Esc to cancel)')
2. PivotCache.RefreshDate changes to current time
Test it

Oh, got it... sorry!

Thanks for the clarification!

Maybe, is possible to catch any action on PivotTable? For example left mouse click on PivotTable? This would solve the problem.

Yeah... The standard solution is not suitable...