GetPivotData Keeps Returning #REF Error


I am working with a file that has two sheets. The first sheet has a PivotTable that pulls in monthly spend projections on purchase order #s from an external data source. The second sheet needs to pull in the data from the PivotTable, however I keep getting a #REF error using the formula below:


=GETPIVOTDATA("[Measures].[Total Client Side Est Billings]",'Spend Projections'!$A$7,"[Project Financial Model].[Dates.Month Year]",B$1,"[Agreement Funding Model].[Agreements.External Agreement Number]",$A2)



Would appreciate any help. Thank you! 

1 Reply
Did you manually type the formula? If not, did you change the layout of the pivot table after entering that formula by any chance?