I created a pivot table summarizing some accounting journal entries
by
account number (eg 1001). In another sheet I am trying to retrieve
the
data from the pivot table using the getpivotdata function by the
account number. This works as long as an amount exists in the pivot
table otherwise it returns a #REF error. Is there any way of
returning
a zero into the cell other than by over writing the formula when no
amount exists in the pivot table?