It's impossible to give you a correct answer without seeing the formula
you're referring to. However, be aware that the GETPIVOTDATA syntax is
different under XL 2000 than it is under later versions, so if you have
upgraded XL recently, that could be the issue.

See here for an explanation of how the function works among the various XL
versions: http://www.contextures.com/xlPivot06.html

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Martin James Thornhill" wrote:


In Excel 2000, I have used a spreadsheet for over 9 months without issue.

All of a sudden, the GETPIVOTDATA function returns #N/A for 75% of its use,
working normally for the other 25%.

The pivot table, and its underlying data, changes every day to the extent
that another day's transactions appear at the right-hand side of the pivot
data. The incremental label is a date; the analysis labels remain unchanged.

Why has GETPIVOTDATA sudden gone inconsistently stupid and what is the
solution?