Hi Chris, <http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/what-happened-to-the-data-analysis-toolpak-or/740ff33a-6ed9-4553-bc09-5cef06ce5f23>
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: <http://www.microsoft.com/downloads/en/details.aspx?FamilyID=EF1E612F-D8E3-4628-9FE4-AD136F0DEBD3&displaylang=en> After you install Service Pack 1, follow these steps to start Solver: • Start Excel. • Click Tools, and then select Add-Ins. • Click to select the check box for Solver.Xlam. • Click OK. <http://blog.officeformac.com/solver-for-excel-for-mac-2011-free-download-gives-you-what-if-analysis-on-steroids/> Solver for Excel for Mac 2011 http://www.solver.com/mac/ Cheers, Ronni On 03/07/2011, at 10:00 AM, Chris Burton wrote: > > Hi Ronni > > Thanks very much for your reply and link. I had another good look at the > installation disk and found the customise section and included the VBA > install. > > However there is no sign of the Analysis ToolPak. > When I reopened Excel I have a small window appear, saying 'Cannot find the > Analysis ToolPak'. Please run the ValuePack Setup to install the Analysis > ToolPak. > > There is no ValuePak Setup on my mac or on the install DVD? Do I need to > download this? > > Kindest regards and many thanks Ronni > > Chris > > > On 02/07/2011, at 2:02 PM, Ronda Brown wrote: > >> >> On 02/07/2011, at 1:30 PM, Chris Burton <c...@it.net.au> wrote: >> >>> Also had another shock today while trying to do some basic stats in the new >>> Excel 2011 but couldnt do anything as this version does not support the >>> Analysis ToolPak, and add in normally supplied with previous versions. >>> >>> Apparently Microsoft are not doing this any longer so I have to revert to >>> 3rd party software!! >> >> Hi Chris, >> >> Did you perform a standard installation or custom installation of Mac Office? >> >> Microsoft returned the Analysis Toolpak add-in that it removed from Excel >> 2008. >> Microsoft says that the new version of Excel supports the add-in the same >> way Excel 2008 did, and that the add-in’s basic functions work in Excel 2011 >> >> Have a read here: >> 2011 without UDFs? >> <http://blog.mclaughlinsoftware.com/2010/11/04/excel-2011-without-udfs/> >> >> Sent from Ronni's iPad -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Unsubscribe - <mailto:wamug-unsubscr...@wamug.org.au>