We have major version update for Excel for Mac (in preview right now). We've just released the new version to Insider Fast participants. You can try it out by going to Help menu > Check for Updates, and then opt into the Insiders program and choose Insiders Fast. You should be offered an update to version 16.x!
In addition to some long-awaited improvements and features, we've updated the architecture of the product, so these early builds may be a little rough around the edges. We need your help putting them through their paces!
These features are available to those of you with an Office 365 subscription in Excel:
Co-authoring and AutoSave for OneDrive and SharePoint files. Changes are automatically saved as you work, and when you co-author with others, you can see their changes as they work.
New and modern chart types: Say hello to Waterfall, Funnel, Histogram, Pareto, Box & Whisker, Treemap and Sunburst - six powerful charts that help you quickly visualize common financial, statistical and hierarchical data.
The following feature is available to everyone:
We've updated Visual Basic for Applications (VBA) in Word, Excel, and PowerPoint. Some additional methods, properties, and objects available to Windows Office users will now work on Mac as well. There are still differences between the Mac and Windows Object Model, so you will still see "not supported on this platform" for some elements. More details on the Object Model changes will be available soon.
You can find more information about the new features (and known issues, if any) in the Office 2016 for Mac Insider Fast release notes. More news is coming in an update to the Insider Fast channel, we'll share details soon.