Refresh Pivot Table: Do you want to replace the destination cells
 

I refresh the pivot table in many different excel files, using in VBA either

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh
or
ActiveSheet.PivotTables("PivotTable1").RefreshTabl e

What I dont get is why "some times" the program stop and request human
intervention with the question

"Do you want to replace the destination cells in Sheet1 ?

Any idea on how to force the answer to "yes" !?!... and go on...

pg

Refresh Pivot Table: Do you want to replace the destination cells
 

I think you need to turn the display alerts off using the following:

Application.DisplayAlerts = False

Nick


--
nickysquawkes
------------------------------------------------------------------------
nickysquawkes's Profile: http://www.excelforum.com/member.php...o&userid=30630
View this thread: http://www.excelforum.com/showthread...hreadid=502834

Refresh Pivot Table: Do you want to replace the destination ce
 

Additionally, I think that DisplayAlerts = false will choose the default
setting of the window that normally would pop up. I have used this before,
but thought there was some caveat about trying to get the thing to do what I
wanted it to do, because the default answer was No or something like that....
Hmmm.. I think nicky is right though, at least that option must be
implemented.

"nickysquawkes" wrote:


I think you need to turn the display alerts off using the following:

Application.DisplayAlerts = False

Nick


--
nickysquawkes
------------------------------------------------------------------------
nickysquawkes's Profile: http://www.excelforum.com/member.php...o&userid=30630
View this thread: http://www.excelforum.com/showthread...hreadid=502834