XL2000: #N/A Error Displayed in Data Field of PivotTable Based on OLAP Data Source

• Microsoft Excel 2000

SYMPTOMS

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

CAUSE

This problem occurs when the following conditions are true:

• You have chosen any of the following settings in the Show data as list in the PivotTable Field dialog box:
  
  
  • Difference From
  • % Of
  • % Difference From
  • Running Total in
  
  -and-
  
  
• Your PivotTable is based on an Online Analytical Processing (OLAP) data source.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000 tensor

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb