C
cm
I am using the following to refresh a pivot table:
Sheets("Summaries").PivotTables("PivotTable2").PivotCache.Refresh
This works properly; however if the table is receiving addtional rows during
the refresh, it displays a question asking the user if they want to update
the table (duh, yes we do).
How can I eliminate this dialog box?
cm
Sheets("Summaries").PivotTables("PivotTable2").PivotCache.Refresh
This works properly; however if the table is receiving addtional rows during
the refresh, it displays a question asking the user if they want to update
the table (duh, yes we do).
How can I eliminate this dialog box?
cm