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
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