>>The structure is actually quite convoluted, << I figured the "seems simple" was just that I was missing the pieces. =)
>>and involves multiple components of the Zip structure, connected by relationship IDs (rIdattributes, _rels files): Workbook.xml Sheet#.xml PivotTable#.xml PivotCacheDefinition#.xml PivotCacheRecords#.xml<< Yeah, I couldn't find a way back to the actual field from the *Cache* structures. >> If cell data is modified the corresponding PivotCacheRecords file needs to be updated as well. I would need to do that. >> If the definition is changed (selecting different metrics, etc.) again the cache needs to be rebuilt/updated. Changing the definition can (and most likely will) change the PivotTable area reference. I wouldn't need to do that. >> Excel has a ton of management code and functionality around keeping all these in sync as the user makes changes. POI has none of that yet. I'm gonna hope this comes in a lot lower on the priorities than some functions I need to add. =P
