Usually, we would define the following macro statement to
get value from an OLAP cube in Excel.

GETPIVOTDATA("[Measures].
[Sales]",$A$4, "[Months]", "[Months].[January]")

I would like to know whether there is another to
use "Getpivotdata". For example, assign an array
to "Getpivotdata".

Thanks!

Cindy