Unable to display cube calculations in Pivot Table
 

I have a cube with quite complex calculated cells, which work fine in cube
еру browser or with MDX. The moment I use Excel 2007 Pivot table, it
shows#Value! instead of the numbers. I thought GetPivotData simply returned
values from the cube and did not do any own calculations. I spent a lot of
time to design the cube, but now it cannot be used from Excel... Any help
woul dbe greatly appreciated.
--
Dmitri