Hi I have a problem with getpivotdata function

[si yuan Lim]

Hi I got a file which I need to populate with the latest sales figure from a pivot table. I checked my get pivot data formula, is correct but it keeps on returning the #ref error. Can someone help me with it?

[#2]

Hi,

Instead if C$3 use TEXT(C$3,"####"). Attached.