topic Pivot Refresh MS Excel VBO - action freezing/pop up in Product Forum https://community.blueprism.com/t5/Product-Forum/Pivot-Refresh-MS-Excel-VBO-action-freezing-pop-up/m-p/75475#M28080 Hello,<BR /><BR />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.<BR /><BR />The coding of the action is as follows:<BR /><BR />GetWorkbook(handle, "").ActiveSheet.PivotTables(PivotTable).PivotCache.Refresh<BR /><BR /><BR />Does anyone have any ideas of how to resolve?<BR /><BR />------------------------------<BR />Chloe MacIntosh<BR />Automation Developer<BR />Zurich Insurance<BR />Europe/London<BR />------------------------------<BR /> Mon, 27 Apr 2020 15:39:00 GMT cvmac 2020-04-27T15:39:00Z Pivot Refresh MS Excel VBO - action freezing/pop up https://community.blueprism.com/t5/Product-Forum/Pivot-Refresh-MS-Excel-VBO-action-freezing-pop-up/m-p/75475#M28080 Hello,<BR /><BR />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.<BR /><BR />The coding of the action is as follows:<BR /><BR />GetWorkbook(handle, "").ActiveSheet.PivotTables(PivotTable).PivotCache.Refresh<BR /><BR /><BR />Does anyone have any ideas of how to resolve?<BR /><BR />------------------------------<BR />Chloe MacIntosh<BR />Automation Developer<BR />Zurich Insurance<BR />Europe/London<BR />------------------------------<BR /> Mon, 27 Apr 2020 15:39:00 GMT https://community.blueprism.com/t5/Product-Forum/Pivot-Refresh-MS-Excel-VBO-action-freezing-pop-up/m-p/75475#M28080 cvmac 2020-04-27T15:39:00Z