PivotCache Data Source

P

Peter

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing pivot table ADO recordset 0
Loading PivotCache directly from a text file 0
pivot table connection access 1
Loading PivotTable data into VBA 0
Pivotcache 1
Gen pivotcache with data filtering/conversion 0
How do I tell the pivot table to ignore the PivotCache and go straight to the data in ConsolidationR 0
Query data within a PivotCache programmatically 0

Top