View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dmitri Dmitri is offline
external usenet poster
 
Posts: 4
Default 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