Ok, think I have it. The extra BSTR in the XML is peculiar to Excel. Once removed and re-persisted as a standard Recordset, the PivotCache elements are replaced by standard ADO schema. I'll mark this as solved, but a final question - do the VBA mid() and len() functions require augmentation of offsets to handle data persisted as Unicode?

again, Thanx

Stan