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 ca...
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.