I want to return a zero value if the result of my getpivotdata formula is
going to return #REF. How do I do this?

Here is the formula:
=+GETPIVOTDATA("USD TOTAL",'[0407 COMBO Pivots.xls]OEM'!$A$3,"Region per
L/U","CAN")

Also.... Is there a way to pull the getpivotdata results onto my report when
the external workbook that it is pulling from is not opened? I've tried
adding the filepath name to the formula string, but that only returns
#REF....please help!!