If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list. In the Manage box, click COM Add-ins> Go.Ĭheck the Microsoft Office Power Pivot box, and then click OK.

Here’s how you enable Power Pivot before using it for the first time. The add-in is built into certain versions of Office, but by default, it's not enabled.įor a list of the versions of Office that include Power Pivot, as well as a list of the versions that do not, please see: Where is Power Pivot? If that doesn’t work, you can use the “Extract Data” option to recover data from the file or you can try to recover the Excel file.Power Pivot is an add-in that you can use to perform powerful data analysis in Excel.

If the files are corrupted, you will be asked whether you want to repair the file or just extract data.At the bottom of the “Open” dialog box, click the small arrow next to the “Open button”, then choose “Open and Repair” from the context menu.If the file still won’t open, click “Browse” and search for the file.Double-click the file you want to open.Alternatively, you can use the Excel keyboard shortcut Ctrl + O.

Select the File tab and click on “Open” to see a list of recently opened files.When this happens, the file is often so damaged that you can no longer open it with Excel by double-clicking the file in the File Explorer. This is especially common if Excel crashes while saving the file, or if a problematic macro prevents the file from being saved correctly. The most common reason for this problem: Excel won’t open a file because the file is corrupted.

Excel 2016 online