Hi Chris and All, Many thanks for the information and feedback. This will come in handy for those of us using Excel.
Kind regards, Philippe 2011/7/11 Chris Burton <c...@it.net.au> > > Hi Ronni, Philippe and others > > Just thought I would let you know how I went with the Analysis ToolPak with > excel. > > Microsoft has indeed dis-continued the use of the above add-in but does has > Solver, for 2011 Excel. > > I have downloaded and installed the alternative for the ToolPak, > StatPlus:mac 2009 and it seems to be pretty good. Easy to use, with > tutorials on different stats to use, and how to use them with your data in > Excel. > > This is an LE (light) version and they ask you to upgrade to the Pro > version, which does has a lot more options and stats procedures. > > I will give a reasonable go over the coming months. > > Best regards > > Chris > > Christopher L.K. Burton > Director > Western Whale Research > PO Box 1076 > Dunsborough WA 6281 > Mobile: 0419 199 120 > Email: c...@it.net.au > > On 03/07/2011, at 3:44 PM, Chris Burton wrote: > > > > > Hi Ronni and Philippe > > > > Thanks very much for your very helpful advice and links. I will get to > and check them out, and let you know how it goes. > > > > Philippe yes I found similar sites that say Microsoft expects us to use > an LE version of StatPlus: Mac. Im not sure about it but will use at the > last resort after I look at Ronni's suggestions. > > > > Kind regards > > > > Chris > > > > > > On 03/07/2011, at 12:30 PM, Ronda Brown wrote: > > > >> > >> 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>