Getting REF# with GetPivotData formula

[PlanetKristi]

I am getting a REF# error with a GetPivotData formula. I haven't gotten it in the past so concerned since the report that it feeds is due today.
I am looking right at the table and have selected the exact cell with data in the table and getting the REF#. All of the components are in the table with same formatting so do not understand why all of a sudden I am getting this error.
Please let me know what else could cause this error to be returned.

 

[Andrew Poulsom]

From Help on GETPIVOTDATA:

If pivot_table is not a range in which a PivotTable report is found, GETPIVOTDATA returns #REF!.
If the arguments do not describe a visible field, or if they include a page field that is not displayed, GETPIVOTDATA returns #REF!.

For further help we would need to see you pivot table and GETPIVOTDATA formula.

 

[PlanetKristi]

http://www5.snapfish.com/snapfish/t...otsc=SHR/otsi=SALBlink/COBRAND_NAME=snapfish/
I am not able to attach a file. Let me know if there is a better way to get the pivot to you.

 

[Andrew Poulsom]

Maybe you need to put 2011 in double quotes.