Microsoft KB Archive/232582

= XL2000: #N/A Error Summarizing Data Field When (All) Member Missing from OLAP Cube =

Article ID: 232582

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q232582



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 choose any of the following settings in the Show data as list in the PivotTable Field dialog box:

 % of Row % Of Column % of Total

-and-

 Your PivotTable is based on an Online Analytical Processing (OLAP) data source.

-and-

 The dimension that you added as a row field or a column field in your PivotTable does not contain the (All) member.</li></ul>

<div class="moreinformation_section">

MORE INFORMATION
The All level is an optional component of a dimension in an OLAP cube. This level contains a single member, named (All), which summarizes the members of that dimension. Excel requires that the (All) member is present in the OLAP cube for dimensions that you want to summarize by % Of Row, % Of Column, or % Of Total in your PivotTable.

Additional query words: XL2000 tensor

Keywords: kbprb KB232582

-

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

© Microsoft Corporation. All rights reserved.