EPPlus
EPPlus copied to clipboard
Having a selection inside a pivot table can cause the pivot to become corrupt.
If you have a selection in a pivot table and refresh the pivot table the xml for selection inside the worksheet xml is not updated or deleted if the pivot table has changed. This causes the workbook to become corrupt. Example:
<sheetViews>
<sheetView workbookViewId="0">
<selection activeCell="A6" sqref="A5:A6 A8:A10"/>
<pivotSelection pane="bottomRight" showHeader="1" axis="axisRow" dimension="1" activeRow="5" previousRow="5" click="1" r:id="rId2">
<pivotArea dataOnly="0" labelOnly="1" fieldPosition="0">
<references count="1">
<reference field="1" count="0"/>
</references>
</pivotArea>
</pivotSelection>
</sheetView>
</sheetViews>