getpivotdata

  • Thread starter Thread starter Pat Salmon
  • Start date Start date
P

Pat Salmon

I am using Excel 2000. I am using the getpivotdata to
retrieve data from the pivot table and having inconsistent
results. It appears to have the correct formula's, but
works for one column and not the next, or for two columns
and misses one.

the formula is:=IF(ISERROR(GETPIVOTDATA($C$12,$C$8 & " "
&TEXT(D7,"mmm-yy"))),0,GETPIVOTDATA($C$12,$C$8 & " " &TEXT
(D7,"mmm-yy")))

Any ideas??

Thanks
 
The cell reference will change from column to column, the
column to the right will reference E7. The formula's
appear to be identical, but only return correct data
sporadially. If the ISERROR function is removed I get a
#N/A result.

Thanks
 
Back
Top