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

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.

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: 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