OLAP PivotTable Extensions is a Free Windows program in the Other category, developed by OLAP PivotTable Extensions. The current version is 0.9.7; you can download it safely from its official source with the download button above.
OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on all types Analysis Services cubes. It supports Analysis Services Tabular, Analysis Services Multidimensional, Azure Analysis Services, and Power BI (both Analyze in Excel and the XMLA endpoint).
The Excel API has certain PivotTable functionality which is not exposed in the UI. OLAP PivotTable Extensions provides an interface for some of this functionality. It also adds some new features like searching cubes, configuring default settings, and filtering to a list in your clipboard. The add-in can be launched from the menu option in the right-click menu for PivotTables.
✨ Features
excelpivot-table
📝 Release notes (0.9.7)
This release contains support for Excel 2013 and Excel 2016 and Excel in Office 365 (Microsoft 365). The installer supports both 32-bit and 64-bit Excel.
To run OLAP PivotTable Extensions in Excel 2007 or Excel 2010, use Release 0.8.4. Release 0.8.4 is not supported to be run side-by-side with newer releases.
New Features
- Upgraded to latest ADOMD.NET driver and forced TLS1.2 which fixed support for:
- Azure Analysis Services
- Power BI Analyze in Excel
- Power BI XMLA endpoints
Bug Fixes
- Fixed Problem Getting Power BI access Token
- Fixed Can't Filter List with Power BI Connection again
- Fixed Error message: App property was not recognized
This release requires the .NET Framework 4.5.2 and will install it if it is not installed already.
Just download and run the EXE. There is no need to uninstall the previous release. If you have problems getting the add-in to work, see the Troubleshooting Installation wiki page.
OLAP PivotTable Extensions documentation is at https://olappivottableextensions.github.io/
SHA-256: 6985E6909D51D38572C8F2D8790907203C732E1D7D632D8BE3CC1828868194E6
