#N/A error displayed in data field of PivotTable based on OLAP data source (231052)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
This article was previously published under Q231052

SYMPTOMS

All the items in a data field in your PivotTable display the #N/A error.

CAUSE

This problem may occur when both of the following conditions are true:
  • You have chosen one of the following settings in the Show data as list in the PivotTable Field dialog box:
    • Difference From
    • % Of
    • % Difference From
    • Running Total in
  • Your PivotTable is based on an Online Analytical Processing (OLAP) data source.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:11/2/2004
Keywords:kbpending kbprb KB231052
©2004 Microsoft Corporation. All rights reserved.