| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to update pivot table data range
Hi all,
I am trying to create Macro in excel 2010 which will change the data range for a pivot table if have added extra datainto the source data worksheet. This is the macro belowbut it returns a runtime error 5 "Invalid procedure Call) error: Sub ChangePivotTableDataRange() ActiveSheet.PivotTables("PivotTable1").ChangePivot Cache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Worksheets("Sales").Range("A5").Curren tRegion.Address _ , Version:=xlPivotTableVersion14) End Sub Any help on this would be greatly appreciated. Taffy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update pivot table data range | Charts and Charting in Excel | |||
| Auto Update Range of a Pivot Table | Excel Programming | |||
| How do I set the pivot table to auto-update the data range? | Excel Discussion (Misc queries) | |||
| Macro to update pivot table data range | Excel Programming | |||
| Update Data Field in Pivot Table with Dynamic Excel Range | Excel Programming | |||
Threaded Mode
