Microsoft KB Archive/830138

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

Article ID: 830138

Article Last Modified on 2/5/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



SUMMARY
Microsoft Excel 2002 and Microsoft Office Excel 2003 provide more OLAP PivotTable functionality than earlier versions of Microsoft Excel, but the extra functionality may have a performance cost when you are using large data sets. The ExcelOLAP_WP.exe file contains the &quot;OLAP PivotTable Considerations&quot; white paper that describes these performance issues and some ways to minimize them.



MORE INFORMATION
The following file is available for download from the Microsoft Download Center:

Download the ExcelOLAP_WP.exe package now.

Release Date: October 2, 2003

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

What follows is the table of contents for PatchDeployment.doc:
 * INTRODUCTION
 * OLAP PIVOTTABLE PROCESSES
 * Non-Empty Algorithms
 * IMPROVING OLAP PIVOTTABLE PERFORMANCE
 * THE NONEMPTYCROSSJOIN FUNCTION
 * DIFFERENCES IN THE WAY THAT EXCEL AND OWC RETRIEVE DATA
 * EXPORTING TO EXCEL FROM OWC
 * FOR MORE INFORMATION

Keywords: kbdownload kbhowto KB830138

-

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

© Microsoft Corporation. All rights reserved.