Turn PowerPivot On

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.

Sub TurnOnPowerPivot()

‘ 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

End If

End If


End Sub

Now I can press ALT+F8 to run the macro.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s