Pivot table refresh


I am facing issue with pivot table refresh in excel. When I am refreshing the pivot table either with vba code or Refresh pivot table activity getting one popup saying that “Do you want to replace the content of the destination cells”. Unable to respond to that popup through bot. Used element exists but no luck…Please help me on this.


Just for trial, try sending hot key enter @Sailaja_Pasupuleti

Good afternoon,

It sounds like activating the sheet with the pivot table on it before refreshing may resolve your issue:

This may also work: Application.AlertBeforeOverwriting = False


Hi Sailaja,

I also face this issue, do you have good solution on it? thanks!

did you try turning off the pop-up using VBA? The last comment has the link to do so

Used parallel activity and closed popup

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.