Hi All,
I got a slight problem with Getpivotdata and using indirect. The original formula is:
=+GETPIVOTDATA("Sum of Month 2008 Act",SAGE!$B$64,"Week",Y3)
I now try to use indirect to make "Sum of Month 2008 Act" variable
I have inputted in cell A1 "Sum of Month 2008 Act" and reworked the formula as below but get a #ref error
=+GETPIVOTDATA(Indirect(A1), SAGE!$B$64,"Week",Y3)
Anyone got an idea what I'm doing wrong.
Cheers
Magnus
I got a slight problem with Getpivotdata and using indirect. The original formula is:
=+GETPIVOTDATA("Sum of Month 2008 Act",SAGE!$B$64,"Week",Y3)
I now try to use indirect to make "Sum of Month 2008 Act" variable
I have inputted in cell A1 "Sum of Month 2008 Act" and reworked the formula as below but get a #ref error
=+GETPIVOTDATA(Indirect(A1), SAGE!$B$64,"Week",Y3)
Anyone got an idea what I'm doing wrong.
Cheers
Magnus