Microsoft KB Archive/231052

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

Article ID: 231052

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: XL2000 tensor

Keywords: kbpending kbprb KB231052

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.