For some strange reason the PowerPivot Add isn’t always started when I start my Excel. I think it might be a conflict with other Com Add-ins that I have installed.
And every time it happens I have to go through File – Options – Add-Ins – Manage -> Com-Add-Ins
Only 8 clicks L.
So to help me I created this Macro in my Personal Workbook.
‘ Activate PowerPivot
Dim c As COMAddIn
For Each c In Application.COMAddIns
If c.Description = “PowerPivot for Excel” Then
If Not c.Connect Then
c.Connect = True
Now I can press ALT+F8 to run the macro.