This formula is missing a range refrence or a defined name

[bves]

I have been trying to put the formula into a text box
=GETPIVOTDATA("AMOUNT",Data!$A$3)

But following error is showing

This formula is missing a range refrence or a defined name

 

[aaewalsh]

You are missing pivot table range reference as the third argument

 

[Umar568]

You are trying to retrieve "AMOUNT" field from PIVOTTABLEDATA in the Data sheet!A3, but I think there is a problem like there is no table named Data, Make sure pivottabledata should be in the same sheet or workbook.

 

[bves]

You are trying to retrieve "AMOUNT" field from PIVOTTABLEDATA in the Data sheet!A3, but I think there is a problem like there is no table named Data, Make sure pivottabledata should be in the same sheet or workbook.

Yes it's in same workbook but another sheet

 

[bves]

You are missing pivot table range reference as the third argument

Yes but I click on the shape box and in formula bar "=" then move to the value which is in another sheet of same workbook then it automatically takes the location and instead of value it shows the error !