Solver and Data Analysis Add-ins for Excel for Mac 2016 Solver Add-in for Excel for Mac 2011 SP1 Resolved: Excel 2016 for Mac - Solver Add-in not allowing cell references to be picked. The Analysis Toolpak is an Excel add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.

Solver was added to Microsoft Office for Mac 2011 in Service Pack 1. You can download and install Office for Mac 2011’s Service Pack 1 by clicking on the link below: When you have installed Service Pack 1 (SP1), follow these steps to start Solver: a. Click Tools -> Select Add-Ins. Click to select the check box for Solver.Xlam. The Data Analysis Toolpak was removed in Mac:Office for Mac 2008. However, you can download a free third-party tool that offers similar functionality.

Possible cure for the add-in woe's. I found this site that offered an add-in (free) to do a Loess.

I was disappointed to find that it was PC only. AND that Excel 2008 doesn't support VB. Well in the help menu there is a suggestion to install a FREE version of StatPlus:Mac Just went to the site and got my 'LE' copy. Haven't used it yet, going to try in a few min's (Please Please Please have Loess!). Apparently there is a 'Pro' version that costs and a 'free trial offer' (30 days).

Not sure if that means that the 'LE' version will expire (doesn't seem like it will, or at least it didn't say in the menu). Give it a shot and post your experience, I think it may be an Apple response to the lack of Stat function in MS Excel, but I may be wrong. Should have follow'd Sararose's link, the StatPlus:Mac can be reach'd there as well. How to partition an external hard drive.