Hello,
We have a Pivot Refresh action within MS Excel VBO, however this has seen some issues in production recently as an unexpected pop up is appearing when attempting to refresh the Pivot table. However, we are unable to identify and spy this pop-up to resolve as the process is getting stuck/frozen on the action as opposed to throwing an exception, so any fix implemented would never be reached by the process.
The coding of the action is as follows:
GetWorkbook(handle, "").ActiveSheet.PivotTables(PivotTable).PivotCache.Refresh
Does anyone have any ideas of how to resolve?
------------------------------
Chloe MacIntosh
Automation Developer
Zurich Insurance
Europe/London
------------------------------
