Add In Data Analysis Tool Pac Not There On Excel For Mac

Solver was added to Office for Mac 2011 in the Service Pack 1 update. You can download and install Office for Mac 2011’s Service Pack 1 by clicking on the link below:

After you install Service Pack 1, follow these steps to start Solver:

  • Go to the Tools menu, select 'Add-ins' Check 'Solver Add-in' and 'Analysis ToolPak' then click OK Select the 'Data' tab, then select 'Solver' or 'Data Analysis'.
  • There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it?
  • I'm trying to follow directions for a PC-centric class with tasks in Excel. Under Tools > Add-Ins I do not have an option to enable the Analysis ToolPak and Analysis Toolpak - VBA, nor do I see 'Data.
  • Once the zip downloads the Data Analysis ToolPak will go through a few steps to import itself into your Microsoft excel application as an add in. Go to your applications folder in your finder menu and open the XLSTAT application.
  • Unlike Excel for Windows and Excel 2016 for Mac, the Data Analysis ToolPak is not included in Excel 2011. The workaround is to add the free StatsPlus Lite Edition to Excel 2011.

1.Start Excel.

2.Click Tools, and then select Add-Ins.

3.Click to select the check box for Solver.Xlam.

There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? There are a few third-party add-ins that provide Analysis ToolPak functionality for Excel 2011. Option 1: Download the XLSTAT add-on statistical software for Mac and use it in Excel 2011. XLSTAT contains more than 200 basic and advanced statistical tools that include all of the Analysis ToolPak features.

4.Click OK.

ALSO:

Add In Data Analysis Toolpak Not There On Excel For Mac

The Data Analysis Toolpak was removed in Office for Mac 2008. However, the following is a free third-party tool that offers similar functionality:

StatPlus:mac LE: http://www.analystsoft.com/en/products/statplusmacle/

The third-party products that this thread discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information
Active4 years, 9 months ago

Does anyone know how to download the data analysis toolpack add-in for Excel 2011 for Mac? I have looked around quite a bit and can't seem to find it anywhere... did Microsoft discontinue this completely?

P.s. I am familiar with the StatPlus software and have used it - that is not what I am looking for. I am looking for the native Data Analysis Toolpak for excel.

samthebrand
70013 gold badges28 silver badges47 bronze badges
daviddavid
3322 gold badges4 silver badges11 bronze badges

1 Answer

Yes, it appears to have been discontinued. Sorry.

Refer to the discussion at What happened to the Data Analysis Toolpak or Solver in Excel for Mac 2011? – answers.microsoft.com. Quote:

The Data Analysis Toolpak was removed in Office for Mac 2008.[emphasis mine] However, the following is a free third-party tool [...]

[... goes on to mention the StatPlus software you already mentioned ...]

See also: I can't find the Analysis ToolPak – Microsoft Office Mac Troubleshooting. Quote:

Cause: Excel 2011 does not include the Analysis ToolPak.

Solution: Download StatPlus:mac LE for free from AnalystSoft, and then use StatPlus:mac LE with Excel 2011.
...

That last link used to include loads of comments from disgruntled Office for Mac users, but Microsoft seems to have removed comment functionality from that help center article. Surely you can find disgruntled comments re: the above elsewhere on the net.

Data analysis toolpak for macsamthebrand
70013 gold badges28 silver badges47 bronze badges
Chris W. Rea

Excel Analysis Toolpak Download

Add In Data Analysis Tool Pac Not There On Excel For MacChris W. Rea
2,94013 gold badges41 silver badges66 bronze badges

You must log in to answer this question.

protected by CommunitySep 12 '13 at 2:49

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Excel Use Analysis Toolpak

Not the answer you're looking for? Browse other questions tagged ms-office .