The "OLAP PivotTable Considerations" Excel white paper is available from the Microsoft Download Center (830138)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002

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 "OLAP PivotTable Considerations" 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:
DownloadDownload 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
Modification Type:MinorLast Reviewed:8/4/2004
Keywords:kbdownload kbhowto KB830138
©2004 Microsoft Corporation. All rights reserved.