When you get the message: "The launcher was not able to connect Analysis Add-In" it means the add-in is disabled.
You can enable the add-in the following way:
- press the Office button
- press the Excel Options button
- Select the Add-Ins options on the left
- Check if Analysis is in the Disabled Application Add-ins section
- Select Disabled Items from the Manage dropdown listbox at the bottom and press Go
- Select Analysis in the Disabled Items popup and press Enable