Thanks again. Just checked out both sites and StackOverflow has a little more recent questions related to OpenXml Pivot Table but not much discussion/answering. Will check that anyway as one can also find something from questions or posted code.
Regarding my original question, I re-watched the video from Bob/Eric, and found the root cause: mishandled relationship id when adding pivot cache entry to the workbook Xml file, partly due to the fact I didn’t know there are multiple .rel files related to a document/package (under the parent node, like a workbook or worksheet).
Thanks, Jim, for reply.
And that’s the other thing: where else do you see more active discussion/help? I did some extensive search and much to my disappointment, and more accurately, to my shock: this is very essential thing and no single sample can be found, and official doc from Microsoft is just a simple syntax/semantic explanation of various objects, without connecting dots…
just got into this Open Xml stuff myself. So, not sure of the exact cause here. I will, however, suggest to consider using Aspsoe.Cells, which is based on OpenXml and really makes most of Excel work much easier: we just did that.