Active4 years, 9 months ago
Solver Add-in for Excel for Mac 2011 SP1 Installing Data Analysis & Solver Add-ins for Excel 2013 Resolved: Excel 2016 for Mac - Solver Add-in not allowing cell references to be picked. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 More. Less If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. However, my Excel version does not show Analysis Toolpak - VBE as an available option and I cannot find any link to download it. I have seen some posts from 2016 that suggest that ATP-VBE caused problems and may have been removed as an option by Microsoft.
Enabling the Data Analysis Toolpak in Excel 2016 for Mac The following instructions are based on Microsoft's published support documentation as of July 7, 2015, and apply only to Office 2016 for Mac. 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. Follow the steps below.
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.
samthebrand7001313 gold badges2828 silver badges4747 bronze badges
daviddavid33222 gold badges44 silver badges1111 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:
Download Data Analysis For Excel
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.
samthebrandAnalysis Toolpak Excel Mac 2011
7001313 gold badges2828 silver badges4747 bronze badges
Chris W. ReaChris W. Rea2,9401313 gold badges4141 silver badges6666 bronze badges
You must log in to answer this question.
protected by Community♦Sep 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?
Would you like to answer one of these unanswered questions instead?
Mac snip tool shortcut. Of course, the most convenient way to snapshot on Mac is by pressing keyboard shortcuts, however, this traditional method lacks additional features like making annotations, uploading images online for sharing, etc. Here's a quick look at these underused options.' His show description: 'Mac OS X makes it easy to take screenshots—images of your screen or objects on it. But even veteran Mac users are often unaware of the many options available for getting the perfect screenshot.
All SpreadTrum device supported. All mobile flash tool.