| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Refreshes Via Code
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button that refreshes all pivot tables at once | Excel Discussion (Misc queries) | |||
| Pivot Table Refreshes | Excel Programming | |||
| Help with Pivot Table Code Please | Excel Programming | |||
| Pivot Table Code | Excel Discussion (Misc queries) | |||
| VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
Threaded Mode
