Skip to content
July 3, 2012 / Erik Svensen

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: Logo

You are commenting using your 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: