Pivot Table Refresh Popup issue

[salman_shaik]

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.

The popup is saying that there is already data in that particular pivot table do you want to replace it?
any way to handle this pop up??
any setting needs to be changed in excel??

------------------------------
Salman Shaik
------------------------------

[alex.oliveira]

Hello Salman,

In terms of Blue Prism what you can do is spy this pop-up and prepare your bot the deal with the options presented there. 

------------------------------
Alexsander De Oliveira
------------------------------