XML Excel Pivot - ConsolidationReference FileName problem

M

Matej Skubic

I have XML Spreadsheet and PivotTable in it.
Data and Pivot is in same file.

It opens ok if file name is equal as in FileName element, but if I
rename file PivotTable is not filled up!


How to reproduce:
- create pivot table and save it as xml
- rename xml file in explorer
- open xml
- excel pop ups error message "Cannot open PivotTable source file"

I tried to delete FileName element... same error
What should be FileName to reference same file???




Pivot definition appended:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook>...
<Worksheet ss:Name="TestPivot">...
<PivotTable>...
<PTSource>...
<ConsolidationReference>
<FileName>test.xml</FileName>
<Name>PivotNamedRegion</Name>
</ConsolidationReference>
</PTSource>
</PivotTable>
</Worksheet>
</Workbook>

Problem XPath: /Workbook/Worksheet/PivotTable/PTSource/ConsolidationReference/FileName
 

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

Top