XL: Error Messages When You Add Dimensions to PivotTable Report (287080)


The information in this article applies to:

  • Microsoft Excel 2002
  • 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 server name.
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.
Modification Type:MinorLast Reviewed:10/1/2003
Keywords:kberrmsg kbbug kbpending KB287080
©2003 Microsoft Corporation. All rights reserved.