I have a workbook in which I want to import some data into PowerPivot, but the "PowerPivot Window" button is greyed out in the PowerPivot ribbon. How can I enable it?
I also tried to post an image of the problem but it says:
My account should be fully verified, so I'm not sure why I'm getting that message....
Note that this workbook has locked up a few times, so I may be using a workbook that has been "opened and repaired". Is that why PowerPivot is enabled?
1. Open File Menu
2. Click on Option
3. In Excel Option Select Add-Ins
4. In Manage select Con Add-In
5. CLick On GO
6. Select Powerpivot for excel
7. Click OK .
This steps applies in Office 2013 . If you have office 2010 please try re installing Power pivot