Hello,

I have trouble trying to install the data analysis toolpak to excel 2013. I follow the steps to get the add in but it still doesnt show up in my data tab. I select the add ins available and click ok and they wont appear. Please help!

Hi,

Please follow this guide http://office.microsoft.com/en-001/excel-help/load-the-analysis-toolpak-HA102749007.aspx to load the Analysis ToolPak again. Make sure you select the Analysis ToolPak check box, instead of Analysis ToolPak VBA. Then please check if the Data Analysis command is available in the Analysis group on the Data tab.

If the Analysis ToolPak doesnt show up, please check within the VBA to see if the add-in is indeed loaded.

1. Open the VBA (alt-f11)
2. Check if there is funcres(FUNCRES.XLAM)

If FUNCRES.XLAM is in it, the analysis toolpak has been loaded.