| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
omit dialog box display during pivot table refresh (macro)
try
Application.DisplayAlerts = False "cm" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
omit dialog box display during pivot table refresh (macro)
Patrick,
That was not successful. The message says exactly "Do you want to replace the contents of the destination cells in Summaries?" Any other ideas? cm "Patrick Molloy" wrote: try Application.DisplayAlerts = False "cm" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
omit dialog box display during pivot table refresh (macro)
I;m not sure what happened the first time, but it seems to be working now.
Thanks a bunch. cm "Patrick Molloy" wrote: try Application.DisplayAlerts = False "cm" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
omit dialog box display during pivot table refresh (macro)
Be sure you have turned Alerts back on when you're. Otherwise, the
user may not get messages that he should. Application.DisplayAlerts = False ' your code Application.DisplayAlerts = True Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 17 Sep 2009 09:45:02 -0700, cm wrote: I;m not sure what happened the first time, but it seems to be working now. Thanks a bunch. cm "Patrick Molloy" wrote: try Application.DisplayAlerts = False "cm" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Auto-refresh a pivot table | Excel Programming | |||
| Run macro on refresh data (pivot table) | Excel Programming | |||
| pivot table refresh macro | Excel Discussion (Misc queries) | |||
| Refresh a pivot table then apply a macro | Excel Programming | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Hybrid Mode
