PivotCache Data Source
 

Hello Everyone - I have a series of pivot tables based on a named range
in another Excel workbook. The source data property of the PivotCache
returns the spreadsheet name and named range. How can I use VBA to set
the PivotCache source data to a full path name of my choosing? The
source spreadsheet will change periodically.

Thanks,

- Peter