Other way to use "Getpivotdata"?
 

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

Other way to use "Getpivotdata"?
 

I hate this method and use VLOOKUP() all the time. No probs at all

--
Message posted from http://www.ExcelForum.com