Microsoft KB Archive/307787

= Excel stops responding when you create PivotTable from a very large OLAP cube =

Article ID: 307787

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office Excel 2003

-



This article was previously published under Q307787



SYMPTOMS
When you attempt to build a PivotTable from a very large Online Analytical Processing (OLAP) cube, Microsoft Excel may use all of the available system resources and stop responding.



CAUSE
This problem may occur when all of the following conditions are true:
 * The OLAP cube contains a calculated member.
 * The Include Hidden Items in Totals button on the PivotTable toolbar is not selected.
 * The query that you used to create the OLAP cube uses at least one NONEMPTY clause.



RESOLUTION
To resolve this problem, select the Include Hidden Items in Totals button on the PivotTable toolbar.

To temporarily work around this problem, you can redesign the OLAP cube to use multiple hierarchies within your dimensions, instead of creating separate dimensions for each hierarchy. Doing so improves the efficiency of the query, but may not completely resolve the problem.

For more information about the benefits of using hierarchies, click the following article number to view the article in the Microsoft Knowledge Base:

306408 Use of multiple hierarchies versus the creation of separate hierarchies

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

830138 The &quot;OLAP PivotTable Considerations&quot; Excel white paper is available from the Microsoft Download Center

Additional query words: sql database db oledb hang hangs hanging hung lock up locks locking locked lockup freeze freezes freezing froze frozen stop stopping stopped won't respond waiting XL

Keywords: kbprb KB307787

-

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

© Microsoft Corporation. All rights reserved.