• Help us make Excel PivotTables faster …
    A long time ago, I posted a request for calculation-intensive workbooks and received a lot of very valuable Excel workbooks in response – again, to those that helped out; it helped the Excel team optimize calculation performance around real-world usage. Currently, the Excel team is thinking about PivotTable performance, and we are looking for examples of large Excel PivotTables to help with our work. Given all the different features of PivotTables that can affect performance, we are always looking...
  • New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
    Another Excel 2007 whitepaper is available. According to the overview, " Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL Server 2005 Analysis Services. To take full advantage of these features, it is important to keep in mind the end-user experience in Office Excel 2007 when you are designing cubes. This document outlines how you can create a good end-user experience by optimizing the cube design for Office Excel 2007 PivotTable dynamic views. " You can find the...