Hi,

1. Did you type the formula or enter it by clicking on the cell in the
PivotTable. It's easy to make typos with this function.
2. Can you still see the value in the pivot table? #REF errors usually mean
that the element you are searching for is no longer being displayed in the
pivot table. For example, if you took a field of the PT.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mariaivelisse77" wrote:

Hi,

I am working with a spreadsheet and I'm trying to use the getpivot data
function with dollar amounts. It has worked for all other figures on my
spreadsheet but when I try to get a number that is $$ the function isn't
working I get the REF error.

My formula looks like this: =GETPIVOTDATA("Average Salary",Sheet1!$A$6,"C-R
Band",".85-.89")

Thanks for any help you can offer!

MIM