Forum Discussion
Convert PivotTable - Excel Add-in
Hi everyone,
I recently watched a video about an Excel add-in that can automatically convert PivotTables into pretty formatted values by replacing the PivotTable structure with normal cells. I can't remember the name of this add-in. Does anyone know what I'm talking about or can provide a link to it?
Thanks in advance!
2 Replies
Maybe this?
Normal PivotTable: https://www.youtube.com/watch?v=c7T24_zR4xM
PowerPivot/Data Model-linked PivotTable: https://www.youtube.com/watch?v=o4OpUbLuQOUBit more explanation on cube formulas https://www.accelerate-excel.com/blog/excel-cube-formulas.
The Accelerate Excel add-in requires a subscription and can be found here: https://www.accelerate-excel.com/
In general that's built-in functionality if creating PivotTable data was added to data model.
Bit more explanations is here Convert PivotTables to Cube Formulas - Monkey Shorts Episode 032 - YouTube and at many other places.
If you work with cached PivotTable, Monkey Tools could convert it to data model PivotTable, depends on which Excel you are.
