How do I tell the pivot table to ignore the PivotCache and go straight to the data in ConsolidationR

P

pnschofield

I'm generating an XML spreadsheet containing a table populated from a
database query. This table is used as the data source for a pivot table
in another worksheet in the spreadsheet. The ConsolidationReference
for the pivot table indicates the range containing this source data.
I'd prefer not to have to populate the same data in the PivotCache
section of the XML spreadsheet, so I'd like the pivot table to go
directly to the source data when the spreadsheet is opened. There
doesn't seem to be a lot of documentation on how this is done.

Thanks in advance for any assistance!

Paul
 

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

Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Changing pivot table ADO recordset 0
How I can set dynamic pivot table ONLY when I have enough data point 1
ConsolidationReference pointing to current file in xml 0
PivotCache Data Source 0
Macro to update pivot table data range 3
Making a ConsolidationReference default to the current workbook. 1

Top