My cubes have calculated members that use Excel functions.
In Excel 2000, I use a cube as the data source for a pivot
table and include one of these calculated members on the
rows in the pivot table. I may have many sheets in one
workbook where one cube is the pivot table source on each
sheet. After opening the xls file, I open the task manager
to find only one session of Excel. Good so far.

Now, on the first sheet, I change the filtering of any one
of the dimensions in the pivot table, and the task manager
shows a new instance of Excel. I assume this is because
the cube is recalculating and has opened Excel to get to
the function definition. If I repeat this on the second
sheet, I get a third instance of Excel appearing in the
task manager. If I have 10 sheets and change the filtering
on each one, task manager will show 11 instances of Excel
running.

Pretty soon, I run out of memory and can't continue.

If I end the process of the Excel that appeared for the
function work, either Excel crashes completely or the
recalc after the filtering fails for the calculated
member.

As I write, I'm thinking there is probably no solution
except to rewrite the calculated member and omit the Excel
function - which will not be an easy job.

What do you think? Think there is another way?

Stoney