pivot table error/question

[dave]

I have a pivot table which has interest rate as one of its
fields and the data is an amount. if I use a cell to the
right of a my table and link it to lets say the total
column within a given interest rate, it gives me that
total correctly using the "getpivotdata" function for all
but one of the rates. The one cell which doesnt work
right gives me the #ref error. I've been researching the
help menu for this function. Neither of the examples of
causes of that error are the case here. I dont know if
this will be possible to answer without seeing the sheet
(its large, but I'd be willing to attach it if it could
help), but any help would be appreciated.

tia,
Dave