Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL: Error Messages When You Add Dimensions to PivotTable Report

XL: Error Messages When You Add Dimensions to PivotTable Report

View products that this article applies to.

This article was previously published under Q287080

↑ Back to the top

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.

↑ Back to the top

Cause

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

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB287080, kbpending, kbbug, kberrmsg

↑ Back to the top

Article Info
Article ID : 287080
Revision : 4
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 322