So, I dynamically created a PivotTable on an empty workbook (with data connections built already), and saved successfully: the document is even opened successfully why Excel GUI: everythign seems right and working properly.
When I looked inside the package, I found the Xml tags have an extar x:, like workbook.xml is like bellow;.
<x:pivotCaches>
<x:pivotCache cacheId=”1″ r:id=”rId4″ />
</x:pivotCaches>
</x:workbook>
Does anyone why we have this extra x:? It only happens after I add pivotCaches tag to the workbook.xml. I am using OpenXml 2.7.1