Maybe the question mark character in the ProductAttributable? field name
is causing the confusion, since Excel uses it as a wildcard character in
some circumstances.

In a copy of the file, can you change the field name, and see if the
problem persists?

Randall wrote:
The oddest new occurrence is the following:

=GETPIVOTDATA("Report",$A$5,"IncidentDate",4,"Prod uctAttributable?","Attributable","Customer","XYZ", "Severe","Yes","Years",2000)

Yields the correct value for April 2000, Customer XYZ Attributable &
Severe events = 0

=GETPIVOTDATA("Report",$A$5,"IncidentDate",5,"Prod uctAttributable?","Attributable","Customer","XYZ", "Severe","Yes","Years",2000)

Yields the error #REF, which is not the number of May 2000 Customer XYZ
Attributable & Severe events which is zero (and I can see the correct
value in the Pivot Table).

For some reason, If I save and reopen the file then recopy the formula
with the error, the correct answer will return momentarily up until I
hit the refresh button on the pivot table (which causes the error to
reappear). Weird!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html