Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.


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

↑ Back to the top


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.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: KB231052, kbprb, kbpending

↑ Back to the top

Article Info
Article ID : 231052
Revision : 6
Created on : 2/15/2012
Published on : 2/15/2012
Exists online : False
Views : 310