![How How](http://dyzz9obi78pm5.cloudfront.net/app/image/id/59c537658e121c5c6aafa0c7/n/picture2.png)
3 days ago - Install Solver Add-in for Excel for Mac 2016. Open Excel for Mac 2016. 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'.
Hello there, I am stuck with a question no one seems able to answer- I've tried all three of our local Apple stores and they haven't been able to tell me. I also don't know any iPad users that have been able to give me an answer either. I have been using a 5S and am very familiar with the functionality of Numbers and Pages. However, I'm a finance student and the fact of the matter is that I have to have access to Excel. I've invested YEARS and thousands of dollars into the iOS ecosystem and I'm very torn over what to do next. I'm hoping to migrate permanently from a laptop to a tablet for my productivity, which involves extremely heavy duty (5+ hours daily) word processing and spreadsheet creation.
Pages handles the job just fine, but Numbers isn't really cutting it; Excel is simply the de facto standard in my line of work. I was pleased as punch when Microsoft finally launched Office for iOS.
If the simple functions were all I needed, my choice would be open and shut. However, it's not.
I must have access to the Solver and Data Analysis toolpaks. This is where it gets tricky.
I have been told by Mac users running Excel that data analysis is not natively supported as it is on a Windows machine. However, no one I know is using full Office through iOS and no one at the Apple Store has been able to answer me definitively on this, either.
Does anyone out there know first hand if the Data Analysis and Solver toolpaks are available on iOS version of Office? I would like to avoid fussing around with another tablet (quality, etc) and the fact that iOS is the only mobile operating suite where I can seemlessly blend Google, Apple and Microsoft, I am really, really, really hesitant to leave it. I am not willing to shell out the money for Office on iOS and run it on my phone (though I love that idea) just to find that it won't do data analysis (I'm all for experiments but that's a bit pricey for a student).
Thanx for your time. TL:DR, does the new Microsoft Office for iOS provide Solver and Data Analysis toolpaks in Excel? Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.