| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Refreshes
Private Sub RefreshButton_Click()
ActiveSheet.PivotTables("NewPT1").PivotCache.Refre sh ActiveSheet.PivotTables("NewPT2").PivotCache.Refre sh End Sub When the above procedure runs, when the Pivottable is larger than the last one, I get a dialog box asking me if I wish to overwrite the existing cells, even though the existing cells are blank. Is there a way I can avoid this, either by adding to my code, or some additional property of the pivoit tables? EA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Button that refreshes all pivot tables at once | Excel Discussion (Misc queries) | |||
| Workbook Refreshes For Multiple Users | Excel Worksheet Functions | |||
| disable screen refreshes | Excel Programming | |||
| How does one refreshes the screen? | Excel Programming | |||
Linear Mode
