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!
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.
Maybe this?
Normal PivotTable: Accelerate Excel | PivotTables | Convert Pivot | Simple Example
PowerPivot/Data Model-linked PivotTable: Accelerate Excel | PivotTables | Convert Pivot | Detailed Example
The Accelerate Excel add-in requires a subscription and can be found here: https://www.accelerate-excel.com/
