PivotTable: qalculated cells

[Andrey Savchenko]

Hi, All!

I have a problem with pivottable. When I am connecting to the OLAP cube
in MS SQL 2k AS which contain calculated cells it seems that Excel
process them on the client side.

Example: I have 2 measures: quantity and total quantity by dimension.

And seems that total quantity by dimension calculated depending on data,
that Excel received from OLAP server.

How can I prevent this and say to the excel do not recalculate this
measure.


PS: other BI clients process this situation ok.

-- -
wbr
Andrey Savchenko

 

[Andrey Savchenko]

Almost forgot,

I use Office XP and Office 2000

-- -
wbr
Andrey Savchenko