The importance of Microsoft Office Update | Fix random crashes

Introduction

The past year we have received several support requests that were actually related to/caused by bugs in Excel 2016/365.
This article show information on how to update your Excel installation and also links to the Microsoft articles with all the detailed information about what has been fixed and improved by the Excel team.

How a bug in Excel may appear to be a bug in ASAP Utilities

Unfortunately, several bugs were introduced in Excel 2016/265 and Excel's VBA/macro language that could cause slow performance and crashes in Excel (1, 2, 3, 4, 5, 6, 7).

Since many users don't use macros themselves, they may only experience such specific Excel bugs (slow speed/crashes) when they use an add-in, such as for example ASAP Utilities, that uses Excel's built-in VBA/macro programming language for its tools and it then seems as if the add-in is faulty. In general, if something goes wrong in ASAP Utilities, you should get a polite error message. It should never make Excel crash.
Most of the times updating Excel will solve it already. If a fix isn't available yet from Microsoft, then we try to create a workaround in ASAP Utilities to handle such Excel bugs, because we do not always know how long it will take the Excel team to fix it.

Fortunately Microsoft has already released many updates with fixes related to the peformance and stability of Excel 2016/365.

How to install Excel/Office updates

Update ExcelTo update Excel/Office to the latest version available:

  1. Start Excel.
  2. Go to File Account
  3. Under Product Information, choose Update Options > Update Now.

Source:
https://support.office.com/en-us/article/Install-Office-updates-2ab296f3-7f03-43a2-8e50-46de917611c5

List of the latest Office Updates

Information on (only) the last Office Updates from Microsoft for Office 2016, Office 2013, Office 2010 and Office 2007 can be found here:
https://support.office.com/en-us/article/Office-Updates-a118ec61-f007-492f-bfa5-5a6f764d5471

Office 365 client update channel releases

On the following page you can see the most recent changes the the Office 365 products. It shows even the recent ones that don't have their own update article yet on the Microsoft Support website. You can choose to only see the updates that impact Excel.
https://technet.microsoft.com/en-us/office/mt465751
https://support.office.com/en-us/article/Version-and-build-numbers-of-update-channel-releases-ae942449-1fca-4484-898b-a933ea23def7

Issues in Excel that Microsoft is aware of - with status updates

Known issues and possible fixes or workarounds from Microsoft Office Support is listed here:
https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093

Excel 2016 Update History

Because there doesn't seem to be a simple page where you can see all the updates/fixes related to Excel, we've created a list with the links to the official articles from Microsoft here.
Several of the fixes from Microsoft were related to the performance and/or crashes of Excel.

Microsoft Office Update History

General MS Office update information for Office 2016, Office 2013, Office 2010 and Office 2007:

 

Leave a Reply

Please answer the following formula: *

Comments will be closed on December 29, 2017.

Pinterest