I've been given an Access database that pulls data from an ODBC source. An
Excel file then links to Access tables. Below is an example of a formula on
an Excel spreadsheet - I am getting #REF errors because, I think, there is no
match in D16 in the pivot table which is because there's no data for either
January or February in the ODBC source. Is there a way to combine an IF
statement with the formula below to put a 0 in the cell so it doesn't error
off? Any other ideas? Any help would be so very much appreciated!! Jani
=GETPIVOTDATA("Recordable1",'Recordable
-CY'!$A$204,"Region",C16,"Location",B16,"Month_",E$ 4,"Division",D16)