I am new to SQL Server OLAP cubes.

The following is the formula in question.

=GETPIVOTDATA("[Measures].[Units]",$A$16,"[Markets]","[Markets].[All
Markets].[South].[Virginia].[Salem]","[Platform Types]","[Platform
Types].[All Platform Types].[center]")

Using normal Excel pivots, I can subsitute excel addresses in the
Getpivotdata function to automate my work. For example,

GETPIVOTDATA("Sum of
"&TRIM(ColList!$H$5),INDIRECT(RegionPivotStartRef) ,"REGION",$A7,"ACTIVATION_MONTH",DATE(YEAR(G$5),MO NTH(G$5),1)

Is this possible with SQL Server cubes? I have tried various ways to
reference Excel cells, but keep getting #REF errors.

Any assistance would be appreciated!

Thanks!