- Update KB4484392 for Office 2016 is ready for download.
- The update patches multiple issues causing MS Excel and PowerPoint to crash.
- Visit the Microsoft Office page for more updates related to all MS Office applications.
- You may also check out our Excel section for everything, from troubleshooting tips to UI guides.
Microsoft Excel hasn’t lost its traditional role as the leading spreadsheet software for manipulating predominantly numeric data. But those of you that have used it for long know that the Windows 10 application can crash for all manner of reasons, from an update that went wrong to a printing or processing bug.
Well, update KB4484392 for Office 2016 addresses an issue that causes Excel crashes. Also, it adds printer DPI support for when you’re pasting Windows Metafile (WMF) files.
Office 2016 update solves MS Excel crashes and more
The VSTO fix
KB4484392 addresses a crash problem that impacted users of Visual Studio Tools for Office (VSTO).
Microsoft describes the problem as follows:
- You have a VSTO Add-in that calls ApplicationFactory.GetVstoObject.
- You add a shape to a workbook and save the workbook as .zip format.
- You add a noSelect property through setting <a:spLocks noSelect=”1″ /> in a drawing xml file.
- You load the add-in in Excel, and then open the workbook.
In this situation, Excel crashes.
Update KB4484392 includes a printer dots per inch (DPI) improvement. It now lets you use DPI when you’re pasting WMF or Enhanced Metafile (EMF) to enhance text spacing.
The added DPI support is optional, even though it’s enabled by default. To disable it, navigate to HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0Common. Then, assign 0 to the EnableMetafileReferenceDevice registry key.
Visio files with EMF graphics
If you cropped EMF graphics to fit on a Visio file, you’d get blurry printouts. This issue is no more with the update Office 2016 just received. However, the fix is optional in the sense that you can disable it.
Cropped EMF shapes
A bug would crop the sides, bottom, or top of copy-pasted EMF shapes.
PowerPoint 2016 issues
If you copied formatted text from MS Excel to PowerPoint, you’d lose the formatting. This bug is no more.
Also fixed is an issue that caused PowerPoint 2016 to crash. The problem occurred if, when working with the Segmented Process SmartArt, the user pushed backspace multiple times to remove the node.
Have you got any MS Excel or PowerPoint experiences you’d like to share? Feel free to leave any recommendations or questions in the comments section below.