Sometimes it happens that PowerPivot crashes and is not loaded again automatically when starting Excel. Here is how you get PowerPivot back on track.
- Open the “File” section from the ribbon
- Choose “Options”
- Choose “Add-Ins”
- At the bottom on the right hand side you’ll find a select box labelled “Manage”
- Choose “Disabled Items”
- Click “Go …”
- Choose the item referring to PowerPivot
- Click “Enable”
- Restart Excel
That’s it. In my experience no handicaps are to be expected. The crashes seem pretty random to me. Like a sudden nervous breakdown – just that Excel doesn’t need time-off to recover.