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!"