Excel 2016 for Mac – Release notes for Insider Fast builds

Insider builds for Office 2016 for Mac are updated on a regular basis to provide new or improved features, security updates and bug fixes.  To see similar information about other Office for Mac apps, go to Release notes for Insider Fast builds of Office 2016 for Mac.

Learn how to install Office for Mac updates, and check out the information below to learn about each Insider Fast release.

Your feedback helps us improve.  If you notice an issue, please click the "smiley-face" button in the top corner of the application to tell us what we can do better or what you like.

Send us your comments_C3_2017930212612

January 16, 2018 release

Version:  16.10 (Build 180114)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed an issue where Excel would crash if you close the last remaining open workbook.

  • Fixed several other crashing issues.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.10 (Build 180109)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed some crashing issues.

  • Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • If you have one workbook open, and you close the workbook, Excel will crash.

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.10 (Build 180102)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed several issues that could lead to a crash.

  • AutoSave would not turn on even when the document is saved in OneDrive or OneDrive for Business.

  • Fixed an issue where some labels in dialogs and on buttons were incorrect in some languages.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.9 (Build 171226)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Minor bug fixes.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.9 (Build 171219)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed crashes.

  • Improved scrolling performance when dragging to expand a selection.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

  • In some languages, the labels in the Preferences dialog are showing incorrect text.

Version:  16.9 (Build 171217)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed several crashes.

  • Typing and navigating could become slow if the VBA project contained user-defined functions and the formula builder pane was displayed.

  • Excel would crash when loading some VBA add-ins.

  • In some languages, setting a date format using VBA with a format containing "yyyy" would enter "yyyy" into the cell rather than the year.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

  • In some languages, the labels in the Preferences dialog are showing incorrect text.

Version:  16.9 (Build 171210)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed several crashes.

  • Fixed an issue which prevented you from setting a value as total for Waterfall charts.

  • Some file properties were being removed from files, including the MacOS color tags.

  • Trace errors was not working.

  • Some help links would take the user to an unrelated Microsoft website.

  • If you had a macro which set ScreenUpdating = False, then Excel would not update the screen after the macro was finished.

  • Some date formats were showing parts of the format code in the cell rather than the date.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.9 (Build 171206)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Numerous fixes to avoid some crashes.

  • Filters for ranges containing dates were not showing all the date values in the filter range dropdown.

  • Sorting by using a macro with Range().Sort was not working.

  • Inserting a function from the Formulas ribbon tab buttons would insert the function twice.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • Some date formats cause the date value to show parts of the date format code rather than the date. 

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.9 (Build 171204)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed numerous crashes.

  • Fixed a problem that prevented being able to paste in the formula bar or in a cell once you've started editing.

  • Improved the appearance of the tooltip and cell highlighting when the mouse hovers over cells while building a formula

  • Fixed a problem with the select all / unselect all checkbox in filter lists.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs.

Version:  16.9 (Build 171129)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed numerous crashes.

  • Fixed an issue that would prevent multi-threaded calculation mode from being enabled if certain add-ins were enabled when you launched Excel.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs. 

Version:  16.8 (Build 171126)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed numerous crashes.

  • Fixed an issue where some cells would appear blank even when they are not blank.

  • Fixed a problem with using keyboard shortcuts to enter date or time with some languages (CMD+; or CTRL+;).

  • Fixed a problem with installing XLAM add-ins from a network location.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs. 

  • If you have certain Excel Add-ins enabled, then Multi-threaded calculation will not be enabled for new workbooks.

Version:  16.8 (Build 171121)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed numerous crashes.

  • Fixed some issues related to text entry with the IME (Input Method Editor) for some languages.

  • Resolved a problem with data connections where extra characters were being displayed in text fields.

  • Fixed a problem with precedent and dependent arrows not appearing when expected in page layout view.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs. 

  • If you have certain Excel Add-ins enabled, then Multi-threaded calculation will not be enabled for new workbooks.

  • Sometimes the contents of cells will appear blank after you use the trackpad to scroll. 

Version:  16.8 (Build 171114)

New or improved Features

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed numerous crashes.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs. 

  • Multi-threaded calculation may not be enabled for new workbooks.

  • Sometimes the contents of cells will appear blank even though they contain a value. This issue is being investigated, but you can still send feedback with a screen shot if you notice this issue. 

Version:  16.8 (Build 171111)

New or improved Features

  • Multi-threaded recalculation - workbooks can now be recalculated faster in many cases with the introduction of multi-threaded recalculation.

  • If you haven't already, be sure to review the major feature updates mentioned in the Oct. 2 update notes.

Bug fixes

  • Fixed numerous crashes, including a crash when using form controls such as buttons and combo-boxes.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs. 

  • If you notice an improvement in calculation speed for a workbook in version 16.8, then open it and save it using version 15.x, the workbook will no longer take advantage of multi-threaded recalculation when you open it again in version 16.8.

  • Sometimes the contents of cells will appear blank even though they contain a value. This issue is being investigated, but you can still send feedback with a screen shot if you notice this issue. 

Version:  16.8 (Build 171107)

New or improved Features

(be sure to review the major feature updates mentioned in the Oct. 2 update notes)

Bug fixes

  • Fixed numerous crashes.

  • Some menu choices were duplicated

  • Pressing CMD+SHIFT+T now inserts an AutoSum formula.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • Inserting a form control will cause Excel to crash.

  • The font size in the formula bar is smaller than expected.

  • In the VB Editor, if you click the object dropdown in the code window (for example the ThisWorkbook object), an error occurs. 

Version:  16.8 (Build 171101)

Bug fixes

  • Fixed an issue which would cause some text to be shown in English even when the Mac OS language was not English.

  • This update includes some fixes to avoid crashing in certain scenarios. Please refer to the Nov. 1 notes for additional fixes that are included.

Version:  16.7 (Build 171029)

New or improved Features

(be sure to review the major feature updates mentioned in the Oct. 2 update notes)

Bug fixes (highlights)

  • New workbooks now open in a smaller window rather than taking up most of the screen.

  • Fixed a problem with the link for "help on this function" when working in the formula builder pane.

  • You can now add a new line of text while editing a cell by pressing OPT+RETURN.

  • Clicking the Excel button in the Visual Basic Editor now shows the Excel window.

  • Fixed a problem where the Visual Basic Editor would appear when you switched to a different sheet in Excel.

  • Fixed a problem with switching to a custom view.

  • Fixed an issue where VoiceOver was not able to announce the number of items found when searching and was not announcing the location when the user navigated to an item that was found by search.

  • Fixed numerous crashes, including when you attempt to use a user-defined function in the formula builder pane.

  • Explanatory notes in the Number Format dialog showed at the wrong time.

  • Fixed a problem with the remove duplicates dialog where some of the buttons and labels were overlapping.

  • With a "right-to-left" oriented worksheet, the horizontal scroll bar would scroll in the opposite direction.

  • Some issues with editing comments have been fixed.

  • Fixed a problem that prevented some VBA macros and add-ins from running

  • Fixed an issue that caused new workbook templates and sign-in pages to show the wrong language after using the VB Editor.

  • Some paper sizes were listed incorrectly in the paper size gallery.

  • Solver would not stop if it reached a configured time limit.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • The font size in the formula bar is smaller than expected.

  • In some cases, the number separators for decimal and thousands specified in the Mac OS preferences are not being used by Excel.

  • Pressing CMD+SHIFT+T does not insert an AutoSum formula.

  • Some number formats are causing number values to show as all hashes (#) even when the column is wide enough.

  • If you drag a window between a Retina screen and a non-Retina screen, the sheet contents may not scale correctly.  To workaround the issue, you can zoom in and out again.

  • Comment arrows may not always appear to connect the comment to the cell.

Version:  16.7 (Build 171020)

Your feedback helps us improve.  If you notice an issue, please click the "smiley-face" button in the top corner of the application to tell us what we can do better or what you like.

New or improved Features

(be sure to review the major feature updates mentioned in the Oct. 2 update notes)

Bug fixes

  • Fixed several problems when using a non-US keyboard.

  • The formula =INFO("system") now gives the correct result "mac".

  • The Text Import Wizard was missing some file types in the Import Format selection dropdown.

  • There were a number of fixes to avoid crashing and/or hanging in certain situations.

  • Numerous other bug fixes.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • When you close a document and the language is non-English, the button that should say "Don't Save" says "Save All".

  • The font size in the formula bar is smaller than expected.

  • In some cases, the number separators for decimal and thousands specified in the Mac OS preferences are not being used by Excel.

  • Pressing CMD+SHIFT+T does not insert an AutoSum formula.

  • Some number formats are causing number values to show as all hashes (#) even when the column is wide enough.

  • If you drag a window between a Retina screen and a non-Retina screen, the sheet contents may not scale correctly.  To workaround the issue, you can zoom in and out again.

  • Comment arrows may not always appear to connect the comment to the cell.

  • When building a formula with the formula pane, the link for help does not work.

Version:  16.7 (Build 171017)

Your feedback helps us improve.  If you notice an issue, please click the "smiley-face" button in the top corner of the application to tell us what we can do better or what you like.

New or improved Features

(be sure to review the major feature updates mentioned in the Oct. 2 update notes)

Bug fixes

  • Fixed numerous problems with copy/paste.

  • Fixed an issue which with sheet tabs so the entire sheet name is visible.

  • There were a number of fixes to avoid crashing and/or hanging in certain situations.

  • Fixed some problems with shortcut keys, including CMD+Arrow to move to the end of the range, CMD+E to center align text, and others.

  • Fixed several issues with setting and saving preferences

  • Fixed an issue with opening all windows for documents with multiple windows.

  • When resizing a row or column by dragging with the mouse, tooltips now appear as expected.

  • Fixed an issue that prevented selecting multiple buttons in a slicer.

  • In the Text Import Wizard, you can now scroll to the right to see all the columns.

  • Fixed an issue with freeze panes displaying incorrectly after zooming.

  • Fixed several issues with VBA, including Application.OperatingSystem now returns the correct value.

  • Numerous other bug fixes.

Known issues

This is still considered a preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • The font size in the formula bar is smaller than expected.

  • In some cases, the number separators for decimal and thousands specified in the Mac OS preferences are not being used by Excel.

  • Pressing CMD+SHIFT+T does not insert an AutoSum formula.

  • The formula =INFO("system") gives the wrong result "pcdos".

  • Some number formats are causing number values to show as all hashes (#) even when the column is wide enough.

  • The Text Import Wizard is missing some file types in the Import Format selection dropdown.

  • New workbooks will be given a default name which is different than in the past. Previously, the default name was "Workbook1", but now it will be "Book1". This could have an impact if you are using scripts or VBA macros that refer to the default file name.

  • If you drag a window between a Retina screen and a non-Retina screen, the sheet contents may not scale correctly.  To workaround the issue, you can zoom in and out again.

  • The application may take longer to start than expected.

  • Comment arrows may not always appear to connect the comment to the cell.

  • When building a formula with the formula pane, the link for help does not work.

Version:  16.7 (Build 171008)

New or improved Features

(be sure to review the major features mentioned in the Oct. 2 update notes)

Bug fixes

  • There were a number of fixes to avoid crashing and/or hanging in certain situations.

  • Fixed some problems with shortcut keys, including CMD+A while editing a cell now selects the text in the cell rather than selecting a range.

  • Fixed an issue in which you select a range, type a value, and press CMD+RETURN. It now commits the value to all cells in the selected range.

  • Numerous minor bug fixes.

Known issues

Here are a few things we're already aware of:

  • New workbooks will be given a default name which is different than in the past. Previously, the default name was "Workbook1", but now it will be "Book1". This could have an impact if you are using scripts or VBA macros that refer to the default file name.

  • If you drag a window between a Retina screen and a non-Retina screen, the sheet contents may not scale correctly.  To workaround the issue, you can zoom in and out again.

  • A number of keyboard shortcuts are not working as expected.

  • The application may take longer to start than expected.

  • Comment arrows may not always appear to connect the comment to the cell.

  • When building a formula with the formula pane, the link for help does not work, and you are not able to close the workbook until you close the formula builder pane.

Version:  16.6 (Build 171001)

Excel for Mac About Box showing version 16.7_C3_201792132824

New or improved Features

  • Collaborate - For Office 365 subscribers, you can edit at the same time with others for workbooks stored in OneDrive and SharePoint.

  • New functions - For O365 subscribers, use the new IFS and SWITCH functions to simplify and shorten your formulas.

  • Better support for charts with a PivotTable as the data source - charts will update if you update the PivotTable.

  • Table Slicers - Add a Slicer to filter your tables quickly.

  • New and modern chart types - for O365 subscribers, visualize your data with new chart types, including Box & Whisker, funnel, histogram, Pareto, sunburst, treemap, and waterfall.

  • Updated Visual Basic for Applications (VBA) - 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.

Bug fixes

  • Page Layout View performance has been improved.

Known issues

This is the first preview of the next major version, so we expect to see some issues.  Please provide feedback about any issues you find by clicking the smiley-face button near the top corner of the application window.  Here are a few things we're already aware of:

  • New workbooks will be given a default name which is different than in the past. Previously, the default name was "Workbook1", but now it will be "Book1". This could have an impact if you are using scripts or VBA macros that refer to the default file name.

  • A number of keyboard shortcuts are not working as expected.

  • The application may take longer to start than expected.

  • Comment arrows may not always appear to connect the comment to the cell.

  • When building a formula with the formula pane, the link for help does not work.

  • With a range selected, if you type and then press CMD+RETURN, it only commits the value into the active cell.

Version: 15.40 (Build170926)

New or improved features

Nothing new this week.

Bug fixes

  • Fixed an issue where the row numbering was reversed and some row numbers or content would appear to be a mirror image of what it should look like.  This was affecting computers with the macOS version 10.13 (High Sierra).

Known issues

  • For computers with a touch bar, Excel would crash when you press the equals sign to begin writing a formula.

Version:  15.39.0 (Build 170913)

New or improved Features

  • Nothing new this week.

Bug fixes

  • Minor bug fixes

Known issues

  • In some cases, the row numbers may have a mirrored appearance and may be in reverse order for a portion of the rows. Also, some gridlines may appear in an unexpected location. This issue has only been seen with Excel installed on MacOS 10.13 (High Sierra).  

Version:  15.39.0 (Build 170905)

New or improved Features

Bug fixes

  • Minor bug fixes

Known issues

  • Nothing new this week.

Version:  15.39.0 (Build 170829)

New or improved Features

Nothing new this week.

Bug fixes

Minor bug fixes

Known issues

Nothing new this week.

Version:  15.38.0 (Build 170822)

New or improved Features

  • Nothing new this week.

Bug fixes

  • Security patch: Added security warning for Excel 4 macro

  • Issue: Crash if some files were opened in a certain order

Known issues

  • Nothing new this week.

Version: 15.38.0 (Build 170815)

New or improved Features

  • Nothing new this week.

Bug fixes

  • Fixed an issue with incorrect row height when re-opening a spreadsheet. The row height increases when you have a spreadsheet containing cells with wrapped text and in which the row height of this cell was adjusted by using the auto-fit feature. This issue affected the previous Insiders Fast release.

Known issues

  • Nothing new this week.

Version: 15.38.0 (Build 170809)

New or improved Features

  • Nothing new this week.

Bug fixes

  • Fixed some minor issues.

Known issues

  • In some cases, the row height will be increased upon opening a document for rows containing cells with wrapped text that have had the row height by using the auto-fit feature.

Version: 15.38.0 (Build 170801)

New or improved Features

  • Nothing new this week.

Bug fixes

  • Fixed some document templates for certain regions so that relevant regional content is included.

  • Fixed some minor issues.

Known issues

  • In some cases, the row height will be increased upon opening a document for rows containing cells with wrapped text that have had the row height by using the auto-fit feature.

Notes & News

  • To report issues or send feedback directly to our team, click the smiley face in the upper-right corner of the app, and then click Tell Us What You Like or Tell Us What Can Be Better.

  • Connect with us and other Insiders through the Office Insider community or by reaching out through Twitter.

  • To get on the Fast level, click Help > Check for Updates > Join the Office Insider program to get early access to new releases > Office Insider Fast.

Version: 15.37.0 (Build 170725)

New or improved Features

  • Nothing new this week.

Bug fixes

  • Fixed an issue where after using FN+Up/Down to page up or down, then deleting a value from a cell, the cell would still appear to contain the value, even though it was actually deleted.

  • Minor bug fixes.

Known issues

  • Nothing new this week.

Version: 15.37.0 (Build 170704)

New and improved Features

  • You can now add images to headers and footers (released in June 2017, but it was not previously documented here).

Insert image in header or footer_C3_2017610163735

  • Bug fixes

  • Images in headers and footers - fixed an issue where the image quality was reduced when printed.

Known issues

  • No known issues at this time.

Additional information:

  • To report issues or send feedback directly to our team, click the smiley face in the upper-right corner of the app, and then click Tell Us What You Like or Tell Us What Can Be Better.

  • If you need to go back to a previous working version, you can go to your Applications folder and move "Microsoft Excel.app" to the trash, and then go to your account page on Office.com to re-install the current non-Insiders version.  You must move the newer version to the trash before installing the older version.

  • Connect with us and other Insiders through the Office Insider community or by reaching out through Twitter.

  • To get on the Fast level, click Help > Check for Updates > Join the Office Insider program to get early access to new releases > Office Insider Fast.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×