As you said you cannot use solver to work, could you provide specific information about this issue? As far as I know this is an known issue in Excel 2016 for MAC. You can't select cells outside of the Solver dialog box like you can in Excel 2011 Solver. When trying to open Excel for Mac, the application stops responding and you may see a spining wheel. Resolution IMPORTANT The location of certain files are different if you have Service Pack 2 (SP2) installed. Jan 15, 2014 I am running MAC OSX 10.8.5 The most current function that is not working is 'DATEVALUE' I have a column of dates currently in the format 'April 15, 2011' and I tried changing the format in 'Format Cells' this did not work.
Add-on 'Solver' Not giving the option of 'Simplex LP' for Microsoft Excel 2016 for Mac This thread will be closed for further posting. You can monitor the progress of the issue in the primary thread. There are differences in the way that the GetOpenFilename method is implemented in Microsoft Windows and in the Mac. The ButtonText parameter is only available for the Mac. Additionally, the FileFilter and MultiSelect parameters are not available for the Mac.
We’ve redesigned,, and to work even better with Microsoft Word, Excel, and PowerPoint. 
Now, more features are supported, including commenting, conditional formatting, and bubble charts.
And each update adds greater compatibility. It’s never been easier to take a Microsoft Office document from your Mac or PC and import it into Pages, Numbers, and Keynote. So you can keep the workflow flowing. See all the ways our productivity apps support popular Microsoft Office features.
• • Excel to Numbers •.
Last updated: October 4, 2017 ISSUE We are aware of an issue affecting Excel 2016 for Mac users. Problems are reported rendering Excel worksheets, causing text to display as backwards or upside-down. STATUS: WORKAROUND This occurs on a Mac with macOS High Sierra beta and Excel 2016 for Mac Insider's Fast update. This should be resolved when the next Insider's Fast update is released. As a workaround, you can the Excel 2016 for Mac Insider Fast version and the production version of Excel on your Mac. Known issues, changed functionality, and blocked or discontinued features • • • Need more help?
Microsoft Excel For Mac Free
Talk to support. If you have an Office 365 for home subscription, or you purchased a one-time download of Office 2016, click the Contact Uslink at the bottom of this page. Ask the community Get help from experts in our forums: for Mac users Provide feedback in Office app You can send feedback directly to our Office teams. For Mac users, in Office 2016 for Mac, click the smiley icon in the upper-right corner. Have a feature request? We love reading your suggestions on new features and feedback about how you use our products!