Understanding why an Excel PowerPivot workbook is so large
User Rating: 5 / 5
During my and Dave Wickert’s SQLPASS session (SQLCAT: A Preview to PowerPivot Best Practices), we had shown to the audience how to view and better understand the PowerPivot database file structure within the Excel workbook. First of all, I’d like to give credit where credit is due – and the thanks really should go to Ashvini Sharma – Power Pivot, Analysis Services, and Integration Services Dev MasterMind. So while the presentation piece is ours – the actual knowledge and know how is his .
Saying this, what do we mean by all of this?
For starters, recall that an Excel utilizing the PowerPivot add-in actually contains the database within the Excel workbook. For more information on this, please refer to For Excel PowerPivot, the database is IN the workbook.