Excel generated =+GETPIVOTDATA("[Measures] formula results in #REF! error

[Sebbo]

Hi,
I have a pivot table whose source data is a powerpivot model. When I try and reference a cell from the pivot table in another formula I get a #REF! error. As an example the pivot table is as follows:

and the formula that has the #REF! result is:

=+GETPIVOTDATA("[Measures].[Sum of Sale]",$A$1,"[Qlikview data].[Posting Date (Year)]","[Qlikview data].[Posting Date (Year)].&[2015]","[Bainbridge LtdVendor].[Currency Code]","[Bainbridge LtdVendor].[Currency Code].&[EUR]")

Any and all help would be appreciated!

thanks
Sebbo

 

[Jerry Sullivan]

Hi Sebbo, A #REF! error result from a GETPIVOTDATA formula typically occurs because the combination of pivot fields and pivot items is not visible in the Pivot Table that is currently displayed.

Even if your formula was initially generated by Excel through your selection of a cell in the Pivot Table, that #REF! error can occur when the Pivot Table is refreshed, filtered, or otherwise changed in such a way that the value is no longer displayed.

BTW, The image that you tried to link points to your local computer, so no one except you can see that image in your post.

 

[Sebbo]

Thanks Jerry, that sorted it. I can't even see the image so obviously did something very wrong. Its my first post but I will learn! thanks again.