| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source Data File Path Change
Hello, I need to know if there is anyway to automatically change the source
data path for a multiple consolidation range pivot table. I know that I could go into the chart wizard and backup to change the source data manually, but I have 25 files I would need to manually update I also have 20 different pivot tables I would need to do it for. An example of one of the source data path's is below. 'Q:\deptshare\Essentia\Finance\Andy\Projects\Finan cial Collaborative\SEPTEMBER\Facility Files\[BLH.xls]BLH'!$G$320:$J$349 I want to replace the part of the file path that is in caps: 'Q:\deptshare\Essentia\Finance\Andy\Projects\Finan cial Collaborative\OCTOBER\Facility Files\[BLH.xls]BLH'!$G$320:$J$349 Would anyone have any suggestions, keep in mind I'm not fluent in VBA, but I'd be willing to try anything. Thanks in advance! -- Thank You Andrew Edmunds |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change pivot table source data via macro | Excel Discussion (Misc queries) | |||
| change data source of pivot table | Excel Discussion (Misc queries) | |||
| Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
Threaded Mode
