OLAP PivotTable Extensions for Windows

Overview of the Add-in

OLAP PivotTable Extensions is a no-cost add-on for Excel that expands what you can do with PivotTables connected to Analysis Services cubes, the Excel Data Model (Power Pivot), and Power BI datasets. It unlocks several advanced operations that aren’t exposed in Excel’s default menus, making it a practical utility for anyone building complex reports or performing deep data analysis.

Main Features

• Send filtered results straight to the clipboard for quick reuse in other applications
• Set and save preferred defaults to speed up repetitive tasks and enforce consistency
• Quickly locate items inside cubes using a built-in search capability
• Access the tool from a PivotTable’s right-click menu for fast, in-context launches

Compatible Data Sources

• Power BI models and connected datasets
• Azure Analysis Services servers
• Multidimensional Analysis Services cubes
• Tabular Analysis Services models and the Power Pivot data model

Benefits for Analysts

This extension fills gaps in Excel’s native PivotTable functionality by exposing advanced options and automation-friendly features. It helps analysts accelerate routine work, reduce manual steps, and explore large cube structures more efficiently — particularly useful for users who rely heavily on multidimensional or tabular data sources.

Alternative Option

• SHAREit Free — a commonly suggested substitute for sharing and moving files quickly between systems and devices