Done doing all these steps, still issue persist : 1. Go to File > Options > Add-Ins.
2. In the Manage box, click COM Add-ins> Go.
Check the Microsoft Office Power Pivot box, and then click OK.
---
1. Go to File > Options > Add-Ins.
2. In the Manage box, click Disabled Items > Go.
3. Select Microsoft Office Power Pivot and then click Enable.
---
1. Close Excel.
2. Point to Start > Run and then type regedit.
3. In Registry Editor, expand this registry key:
If you have Excel 2013: HKEY_CURRENT_USER > Software > Microsoft > Office > 15.0 > User Settings.
If you have Excel 2016: HKEY_CURRENT_USER > Software > Microsoft > Office > 16.0 > User Settings
4. Right-click PowerPivotExcelAddin and then click Delete.
5. Scroll back up to the top of Registry Editor.
6. Expand HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins.
7. Right-click PowerPivotExcelClientAddIn.NativeEntry.1 and then click Delete.
8. Close Registry Editor.
9. Open Excel.
Enable the add-in using the steps at the top of this article.
