Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change SourceData in Excel PivotTable via VBA
I am updating a number of files that all require the same pivot table
so I am copying a "standard" pivot table (actually, the whole workshee the pivot table is in) from one file and pasting it to each file. A this point, all I want to do is update the SourceData to reflect named region ("RawData") in each file. The following gives me an error: ActiveSheet.PivotTableWizard SourceType:=xlDatabase, _ SourceData:="RawData" ActiveSheet.PivotTables("RT Data").PivotCache.Refresh The pivot table is called "RT Data", so that is not the error. Doe anyone have any suggestions -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change SourceData in Excel PivotTable via VBA
What error do you get, and which line is highlighted?
CarlsonClan < wrote: I am updating a number of files that all require the same pivot table, so I am copying a "standard" pivot table (actually, the whole worksheet the pivot table is in) from one file and pasting it to each file. At this point, all I want to do is update the SourceData to reflect a named region ("RawData") in each file. The following gives me an error: ActiveSheet.PivotTableWizard SourceType:=xlDatabase, _ SourceData:="RawData" ActiveSheet.PivotTables("RT Data").PivotCache.Refresh The pivot table is called "RT Data", so that is not the error. Does anyone have any suggestions? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic sourcedata when copying chart within sheet | Charts and Charting in Excel | |||
Excel/chart/sourcedata - should let me set the left or right axis | Charts and Charting in Excel | |||
MS Excel 2000 - Change PivotTable DataSource (Access2000 database) | Excel Discussion (Misc queries) | |||
Setting up a SourceData:= in VB | Excel Programming | |||
Dynamic Array as pivot table SourceData..? | Excel Programming |