CUBE FUNCTIONS!
 

Hi, I'm trying to create an add -in for Analysis Services in Excel connecting
to an OLAP cube and use the new CUBE functions to manipulate the data in the
worksheet.

The steps I'm taking a

Create a pivot table that connects to an external source: cube (ie
'foodmart 2000'), add pivot fields into the report filter. Just a plain pivot
table with no fields added to the rows or columns.

In a separate cell try to use the CUBEMEMBER function (ie
"=CUBEMEMBER("foodmart", "[Account]")".

All works fine until this point. Save the file using "SaveAs" as an
OpenXMLfileFormat. Close the file and reopen it...

A message box pops up saying "This document is corrupt...". Click ok, the
file will be 'repaired'; re-save it and re-open it... Same error. The
'repaire' step says that the volatileDependencies part was removed "

- <RemovedPartRemoved Part: volatileDependencies part (Volatile External
Dependencies (VolDep) formula reference) with XML error. Line 2, column
183.</RemovedPart

Anyone has any idea?