Excel 2016 articles, fixes and updates - Year 2019

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2016 that have been released in Year 2019. The list is daily updated.

• 3020607 Cannot open Word documents or Excel spreadsheets from an external source in Outlook Q3020607 KB3020607 November 21, 2019
• 2912722 Can't preview Office documents in Outlook if Windows Firewall Service is disabled Q2912722 KB2912722 November 21, 2019
• 214326 Excel incorrectly assumes that the year 1900 is a leap year Q214326 KB214326 August 30, 2019
• 214019 Method to determine whether a year is a leap year Q214019 KB214019 August 30, 2019
• 3001579 "An error occurred when sending commands to the program" error in Excel Q3001579 KB3001579 May 28, 2019
• 2994633 Excel: How to Troubleshoot Excel opening blank when you double-click a file icon or file name Q2994633 KB2994633 May 28, 2019
• 922850 Error message in Office when a file is blocked by registry policy settings Q922850 KB922850 May 28, 2019
• 833041 An Office program is slow or may appear to stop responding (hang) when you open a file from a network location Q833041 KB833041 May 28, 2019
• 291308 How to select cells/ranges by using Visual Basic procedures in Excel Q291308 KB291308 May 28, 2019
• 2815384 Count The Number of Cells With Specific Cell Color By Using VBA Q2815384 KB2815384 May 27, 2019
• 2797062 "Microsoft Office cannot verify the license for this product" error when you start an Office app Q2797062 KB2797062 May 27, 2019
• 2768648 Display issues in Office client applications Q2768648 KB2768648 May 27, 2019
• 2758592 How to troubleshoot crashing and not responding issues with Excel Q2758592 KB2758592 May 27, 2019
• 271513 How to troubleshoot errors when you save Excel workbooks Q271513 KB271513 May 27, 2019
• 213904 You receive a "Too many different cell formats" error message in Excel Q213904 KB213904 May 27, 2019
• 213889 Description of formulas to count the occurrences of text, characters, and words in Excel Q213889 KB213889 May 27, 2019
• 3140179 Office applications don't start when Windows is running in safe mode Q3140179 KB3140179 May 20, 2019
• 2849035 Office program crashes caused by Btmofficea.dll or Btmoffice.dll Q2849035 KB2849035 May 20, 2019
• 2758876 Add-ins are user re-enabled after being disabled by Office programs Q2758876 KB2758876 May 20, 2019
• 826922 How to prevent files from opening automatically in Excel Q826922 KB826922 May 9, 2019
• 2804532 Change the payment method or credit card linked to your Microsoft account Q2804532 KB2804532 March 28, 2019
• 2779852 How to troubleshoot "available resources" errors in Excel Q2779852 KB2779852 March 28, 2019
• 902324 Recalculation of an Excel worksheet that contains a SUMIF formula takes longer than expected to finish Q902324 KB902324 March 20, 2019
• 3070372 How to clean up an Excel workbook so that it uses less memory Q3070372 KB3070372 February 26, 2019