How to permanently enable the PowerPivot add-in in Excel 2010.

[alfranco17]

Hi.

I have an issue with the PowerPivot add-in: when I restart my computer, its checkmark goes away and I have to go to File - Options - Add-ins - COM - Go. Checkmark it and it comes back.

It is not a big problem, but it is rather annoying.

In Word I know I can force an add-in to be enabled by moving it to the START folder. Is this something that could be done with Excel? Is there some other way to force the PowerPivot add-in to load automatically?

Thanks.
Armando.

 

[mikeTRON]

Mine does that as well for my 2010...

 

[KegNot]

I know it's an old thread but maybe my findings can help someone...

I can confirm that the issue has to do with having a Personal.XLSB file in C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART. If there is no file: no PowerPivot issue.
I found out the issue is related to the Personal.XLSB being invisible. It is loaded automatically and invisibly, to supply macros to all workbooks.
If however you make it visible, PowerPivot will no longer disappear! But then Personal.XLSB will be visible all the time, which is a nuisance. But now PowerPivot and macros can be used together, which is better than before.

I'm going to report this to Microsoft. See if they can come up with a solution.