Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivottable: how to change source
hi. i want to know how to update an new data range of pivot table?
i create a pivot table with this range: name = "[" & fso.GetFileName(datei) & "]" & blatt & "!R4C2:R400C5" 'range: r4c2:r400c5 Application.ThisWorkbook.Worksheets("Pivot").Pivot TableWizard SourceType:=xlDatabase, _ 'creation of pivot table SourceData:=name, tabledestination:=Application.ThisWorkbook.Workshe ets("Pivot").Range("A9"), _ tablename:="Pivot1" now i want to change the range of "Pivot1" to r4c2:r200c5 , but i don't know how i can do this. i tried Application.ThisWorkbook.Worksheets("Pivot").Pivot Table("Pivot1").sourcedata = name = "[" & fso.GetFileName(datei) & "]" & blatt & "!R4C2:R200C5" but it didn't work. bye chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED TO KNOW THE SOURCE OF A PIVOTTABLE FROM ACCESS | Excel Discussion (Misc queries) | |||
Select different source data for a PivotTable | Excel Worksheet Functions | |||
PivotTable Source & Destination | Excel Programming | |||
PivotTable Source & Destination | Excel Programming | |||
Changing PivotTable source | Excel Programming |