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.

 

[StrafeXL]

I have the same problem with my PC at work. I am not an administrator on the PC and the add-in was installed for me by IT. I'm wondering if you need to be logged in as an administrator when you enable the add-in to make it stick?

 

[RobertCotton]

I have the same problem but I have admin rights on my machine. This seems to be a common issue. A solution would be greatly appreciated.

 

[benishiryo]

adding on to the list of people who has a problem with this. seems like there are no answers anywhere

 

[DeusXv]

I'm gonna bump this as I'm in the same situation and being the lazy sod that I am I would like a solution to this too :D

 

[powerpivotpro]

Question for all of you: do you have files in XLSTART? For me this is C:\Users\rob\AppData\Roaming\Microsoft\Excel\XLSTART

I have Personal.XLSB in there, and I have this "goes away" problem. But I'm pretty sure that I don't have this problem when XLSTART is empty.

 

[StrafeXL]

As a matter of fact, I do. I'll remove it and see how things go.

 

[alfranco17]

XLSTART is empty. It was not the problem.

 

[StrafeXL]

It's been 3 days and I haven't had to re-enable PowerPivot once, so I'm going to consider this solved.

"This case is getting closed!" Thanks Rob!

 

[DeusXv]

Well day made after seeing that pic. Think I deserve an early lunch too