Thread: omit dialog box display during pivot table refresh (macro)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CM CM is offline
external usenet poster
  
Posts: 136
Default omit dialog box display during pivot table refresh (macro)
I am using the following to refresh a pivot table:

Sheets("Summaries").PivotTables("PivotTable2").Piv otCache.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
Reply With QuoteReply With Quote