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

[pgchop]

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

ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
or
ActiveSheet.PivotTables("PivotTable1").RefreshTable

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

[nickysquawkes]

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

Application.DisplayAlerts = False

Nick

[GB]

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
>
>