quick Q. i dont want excell to ask me...

[uveenhacked]

how can i automatically refresh my pivot table, acctually i made a button for it, and assign this,

Sub Refresh_pivot()
ActiveSheet.PivotTables("PivotTable4").PivotCache.Refresh
ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub

but excell always ask me this:

do you want to replace the contents of the destination cells in (worksheet name)?

i dont want excel do ask me... what should i do?

thanks in advance.

 

[Tazguy37]

Have you tried using:

ActiveWorkbook.RefreshAll

 

[uveenhacked]

hello Tazguy37, i can't use refresh all cause i have a code that stamp dates automatically (hardcode). but when ever i use refresh all, all dates are refreshed. thats why i have to refresh pivots only.

 

[Tazguy37]

Perhaps add:

Application.DisplayAlerts = False

to the beginning of your code, and

Application.DisplayAlerts = True

to the end.

 

[Tom Urtis]

Maybe you can sandwich your code in between

Application.displayalerts = False
Your code
Application.displayalerts = True


or
Application.AlertBeforeOverwriting = False
YourCode
Application.AlertBeforeOverwriting = True


I keep my Tools > Options setting on the Edit tab for that set to False, hate seeing that message also, macro or not.

 

[uveenhacked]

wow! thanks... same answer huh! thanks taz and tom!

-jerry. :D