Posted to microsoft.public.excel.programming

Peter[_57_] Peter[_57_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update PivotCache	Staaan	Excel Programming	0	November 30th 05 10:49 AM
Pivot Table data source "data source contains no visible tables"	Jane	Excel Worksheet Functions	0	September 29th 05 08:28 PM
Delete PivotCache	sorin	Excel Programming	1	June 21st 05 09:03 PM
How can i set the source-data-range of pivottable2 to the source .	Piet	Excel Discussion (Misc queries)	0	March 5th 05 09:31 PM
Re-create source data from pivotcache	George Kramer	Excel Programming	0	May 6th 04 03:35 PM

All times are GMT +1. The time now is 03:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us