In our lab environments, we are having some trouble getting the analysis toolpak enabled and available on the data tab in the ribbon. Originally, the add-in is not checked in add-ins, so we check it and nothing appears in data tab. All of the files necessary are sitting in the library folder. Completely uninstalling and reinstalling doesn't work either. I have all of the office tools, and add-ins set to "Run on my computer". Can someone please help?

On a side note, it also seems like my other add-ins don't work either. 

Hi

Take the following steps to get Data analysis displayed on the ribbon.

Go to File>Add-ins>Manage Excel add-ins>Select the Analysis Toolpak.

Also it is recommended we cancel the select of Disable all application add-ins

Regards

Tylor Wang
TechNet Community Support

Go to File>Add-ins>Manage Excel add-ins>Select the Analysis Toolpak.

Tylor,

This step has already been done, ad nauseum, hoping that one time it might work. The exact same step works in my virtual environment, but I can't get it to work in my normal environment. All of the excel add-ins are checked for install, I enable them later after install, and on some of them I get errors. In the case of the analysis toolpak, I don't get an error. It just doesn't show up in the ribbon.

Thanks,

Geoff

Hi

Check you select "Analysis ToolPak" and not "Analysis ToolPak VBA"

Make sure the add-in is checked and then check within the VBA to see if the add-in is indeed loaded.

Open the VBA (alt-f11)

Show the project explorer (ctrl-r)

Look for funcres(FUNCRES.XLA)

If that doesn't show up, then the analysis toolpak isn't loaded.

Maybe reinstalling from the distribution disk would be order.

Regards

Tylor Wang
TechNet Community Support

• Proposed as answer by TylorWangMicrosoft contingent staff, Moderator Wednesday, September 11, 2013 7:21 AM
• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Wednesday, October 09, 2013 2:41 PM

I follow your step and the FUNCRES.XLA did show up. To me, the analysis toolpak is loaded but in 2010, the ribbon still missing. We did a lot of stiging on office, any GPO that will prevent the ribbon from showing?    

• Edited by Killachang 13 hours 1 minutes ago