Aug 31 2018 03:49 AM
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?
Aug 31 2018 09:18 AM
Hi,
Instead if C$3 use TEXT(C$3,"####"). Attached.