Microsoft KB Archive/237469

= XL2000: PivotTable Updated Slowly with OLAP Data Source =

Article ID: 237469

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q237469



SYMPTOMS
When you pivot or refresh a PivotTable, it takes a long time for Excel to update the PivotTable, and Excel may appear to stop responding.



CAUSE
This behavior occurs when you create a PivotTable in Microsoft Excel 2000 and all of the following conditions are true:
 * The data source for the PivotTable is an Online Analytical Processing (OLAP) server.

-and-
 * The PivotTable contains a large number of row and column headings.

-and-
 * The calculated data for the PivotTable contains empty records for some of the PivotTable fields, making the PivotTable appear sparse.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.



MORE INFORMATION
A PivotTable that you create from data stored on an OLAP server is updated much more slowly than a similar PivotTable that you create from data stored on another server, such as SQL Server. This behavior is noticeable when you perform an action that causes your PivotTable to be refreshed, such as changing the layout.

Before Excel displays summarized data in a PivotTable report, an OLAP server performs calculations to summarize the data and then returns the summarized data to Excel. An OLAP server returns new data to Excel every time you change the view or layout of the PivotTable or PivotChart report. Whereas a non-OLAP external database returns all the individual source records, and then Excel does the summarizing. Consequently, OLAP databases provide Excel with the ability to analyze much larger amounts of external data.

For additional information about OLAP PivotTables, click the article number below to view the article in the Microsoft Knowledge Base:

234700 XL2000: Differences Between OLAP and Non-OLAP PivotTables

Additional query words: XL2000 tensor performance hang hangs hanging hung lock up locks locking locked lockup freeze freezes freezing froze frozen stop stopping stopped won't respond waiting

Keywords: kbbug kbpending KB237469

-

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

© Microsoft Corporation. All rights reserved.