Hi,

Is it possible to serialize and de-serialize the meta data of a pivot table
to/from an XML or any other format?

I saw that if I save a workbook that contains a pivot table as an XML
spreadsheet there is an xml representation for the pivot table, is there an
api for retrieving and setting that format?

If not, is there a way to set the MDX into a pivot table object and not just
getting it?

Thanks,
Keren