M
Mike
I am currently using Excel 2000. I have a file that uses pivot tables
and the Getpivotdata function. Recently I was updating some of the
information in the main data table that updates the pivots (I was
actually only removing some lines). When I refreshed the pivot, the
Getpivot data formula stopped retuning numbers, even though there is
numbers in the pivot. The formula looks like this:
=IF(ISERROR(GETPIVOTDATA('Master Pivot'!$A$9:$U$47,"Volume
Allied")),0,GETPIVOTDATA('Master Pivot'!$A$9:$U$47,"Volume Allied"))
If I remove the ISERROR funtion, I am returned an #N/A error message.
It appears that the problem lies in the second constraint. If I remove
the "Allied", it will return the total volume. If I pivot in any other
fields, they will work. For some reason this field is the only one that
does not (except for the grand total, which does work). I have not
changed the format of the field, but for some reason none of its
variables work.
Can anyone help?
and the Getpivotdata function. Recently I was updating some of the
information in the main data table that updates the pivots (I was
actually only removing some lines). When I refreshed the pivot, the
Getpivot data formula stopped retuning numbers, even though there is
numbers in the pivot. The formula looks like this:
=IF(ISERROR(GETPIVOTDATA('Master Pivot'!$A$9:$U$47,"Volume
Allied")),0,GETPIVOTDATA('Master Pivot'!$A$9:$U$47,"Volume Allied"))
If I remove the ISERROR funtion, I am returned an #N/A error message.
It appears that the problem lies in the second constraint. If I remove
the "Allied", it will return the total volume. If I pivot in any other
fields, they will work. For some reason this field is the only one that
does not (except for the grand total, which does work). I have not
changed the format of the field, but for some reason none of its
variables work.
Can anyone help?