custom functions stop working in PivotTable in Excel2003

M

Mike Melnikov

Hello.

I have OLAP with calculated measures and i am using there
custom functions via COM objects.

everything works fine in Excel2000.

but in Excel2003 COM object was created and then
immediately released by Excel.

so i get #VALUE result in table.

may be there are some security or thread issues?

Does anybody use custom function in MS OLAP with Excel
2003.

BTW, it works in CubeCellValue add-in in Excel2003.

Can anyone help me?

Mike.
 
Top