Office 2016 gets stability update to fix MS Excel crash bugs

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.

BEST PRICES FOR NOVEMBER 2024

Private Internet Access

World-class 24/7 support with 83% for a 3 years plan and 3 months free.

4.9/5

Get 83% off ►

Express VPN

Amazing connection speed with 35% off and 3 months free for the 1-year plan.

4.7/5

Get 35% off ►

CyberGhost VPN

Best security protocols with 83% off and 2 months free for a 2-year plan.

4.6/5

Get 83% off ►

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.

WMF pasting

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.

[wl_navigator]