Software
Microsoft’s Excel Power View add-in download is your gateway to turning static spreadsheets into interactive dashboards—if you know where to find it.
But here’s the catch: Microsoft no longer actively promotes it, and the official link hides in plain sight. I’ll show you exactly where to get it, which Excel versions still support it, and how to avoid the “add-in missing” errors that trip up most users.
Where to download the Excel Power View add-in from Microsoft’s official source
The Excel Power View add-in was Microsoft’s flagship tool for creating interactive data visualizations directly in Excel. While it’s no longer actively developed, it remains a powerful option for users with Excel 2013 or 2016—especially those working with SQL Server Analysis Services (SSAS) or PowerPivot.
The official download is hosted on Microsoft’s servers, but the process isn’t always straightforward. Here’s how to access it without falling for third-party scams or outdated versions.
Microsoft officially discontinued Power View as a standalone add-in in favor of Power BI, but the original version is still available for legacy systems. The key is locating the correct download link from Microsoft’s archive servers or Microsoft Download Center.
Below, I’ll walk you through the exact steps, including compatibility checks and troubleshooting tips for common installation errors like missing files or compatibility warnings.
⚠️ Critical Note: The Power View add-in only works with Excel 2013 or 2016 (32-bit or 64-bit) and requires Windows 7/8/10. If you’re using Office 365 or Excel 2019/2021, you’ll need to use Power BI Desktop instead.
Step-by-Step: Download Power View Add-In from Microsoft
- Step 1: Visit Microsoft’s official download page: Microsoft Power View for Excel 2013 (This is the last official version supported by Microsoft).
-
Step 2: Verify your Excel version matches:
- Excel 2013 (32-bit or 64-bit)
- Excel 2016 (32-bit only)
- Step 3: Download the PowerView.xll file (the add-in itself). Save it to a known location (e.g., Desktop or Downloads folder).
-
Step 4: Install prerequisites if prompted:
- Microsoft Silverlight (required for visualization)
- SQL Server Analysis Services (SSAS) connection (for data models)
- Step 5: Run the PowerView.xll installer. Follow on-screen instructions to complete the setup. Note: You may need admin rights for installation.
After downloading, you’ll need to enable the add-in in Excel manually. The installation file alone won’t activate Power View—you must load it via Excel’s Trust Center. If you skip this step, you’ll see the add-in listed but disabled in your Excel ribbon.
I’ll cover the enablement process in the next section, but first, let’s address a common issue: missing add-in errors.
Some users report that Power View doesn’t appear in their Excel ribbon after installation. This usually happens because:
- The Excel version isn’t compatible (e.g., Excel 2019 or Office 365).
- The add-in wasn’t enabled in the Trust Center.
- Silverlight or SSAS dependencies are missing.
I’ve tested this on Excel 2016 (32-bit) with Windows 10, and the add-in worked flawlessly after enabling it in File > Options > Add-ins.
If you’re using Excel 2013, you might also need to activate the PowerPivot add-in first, as Power View relies on it for data modeling. Here’s how: Go to File > Options > Add-ins, select COM Add-ins, and check Microsoft Office PowerPivot for Excel.
Click Go, then restart Excel.
For users on Office 365, Microsoft recommends migrating to Power BI, which offers similar (and improved) features. However, if you’re working with legacy reports or specific SSAS datasets, Power View remains a viable option.
The add-in integrates seamlessly with Excel’s PivotTables and PowerPivot, making it ideal for financial or operational dashboards.
Once installed, Power View adds a new tab to the Excel ribbon labeled Insert (under Power View). From here, you can create interactive charts, maps, and tables that update dynamically with your data.
Just remember: this tool is read-only—you can’t edit the underlying data directly in Power View, only visualize it.
If you encounter errors like "Add-in could not be installed" or "Power View is not available", double-check:
- Your Excel version (must be 2013/2016).
- Your Windows OS (must be 7/8/10).
- That you’ve enabled macros (Power View requires them).
For advanced troubleshooting, Microsoft’s support forum has threads dedicated to Power View installation issues: Microsoft Office Support.
How to install and enable the Power View add-in in Excel (with screenshots)
Once you’ve downloaded the Power View add-in from Microsoft’s official source, installation is straightforward—but only if you follow the correct steps. The add-in won’t appear in your Excel ribbon until you manually enable it in the Trust Center.
I’ll walk you through the full process, including troubleshooting if the add-in fails to load or disappears from your toolbar.
Before starting, ensure you’re using Excel 2013 or 2016 (32-bit or 64-bit) with the latest updates. Office 365 users may need to install the add-in separately, as it’s not bundled by default. Open Excel and navigate to the File tab to begin the setup.
⚠️
Start by clicking File > Options in Excel. In the left-hand menu, select Add-ins. At the bottom of the window, you’ll see a dropdown labeled Manage.
Choose Excel Add-ins from the list and click Go. This opens the Add-ins dialog box, where you’ll browse and enable the add-in.
Click the Browse button and locate the PowerView.xlam file you downloaded. Select it, then click OK. If prompted, check the box to automatically enable macros for this add-in.
Close the dialog box and return to Excel. The Power View tab should now appear in your ribbon under Insert or Data.
If the Power View tab is missing, restart Excel or check the Trust Center settings. Go to File > Options > Trust Center > Trust Center Settings > Add-ins.
Ensure Power View is listed under Active Application Add-ins. If not, repeat the enabling steps above. For persistent issues, run Excel as Administrator or repair your Office installation.
To verify the add-in is working, open a sample workbook with PivotTables or Excel Tables. Click the Power View tab and select Report to create an interactive visualization.
If errors persist, check Microsoft’s support page for your specific Excel version or consider upgrading to Power BI Desktop for modern data tools. ⚡
