Microsoft KB Archive/287080

= XL: Error Messages When You Add Dimensions to PivotTable Report =

Article ID: 287080

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office Excel 2003

-



This article was previously published under Q287080





SYMPTOMS
When you try to add nine or more dimensions to a PivotTable report, you may receive an error message similar to one of the following:

Excel cannot complete this task with available resources. Choose less data or close other applications.

Cannot instantiate the MSOLAPUI80.dll prompt dialog component.

The operation requested failed due to security problems - unknown error.

Alternatively, Microsoft Excel may stop responding (hang), and Running OLAP query may be displayed in the status bar.



CAUSE
This issue occurs when Excel runs out of memory while you are creating a PivotTable report with data from an OLAP server.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2002

Keywords: kberrmsg kbbug kbpending KB287080

-

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

© Microsoft Corporation. All rights reserved.