Applies ToOffice Home and Business 2016 Office Home and Student 2016 Office Professional 2016 Office Professional Plus 2016 Office Standard 2016

This article describes update KB3114517 for Microsoft Office 2016, which was released on June 7, 2016. This update has a prerequisite.Be aware that the update on the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016. It doesn't apply to the Office 2016 Click-to-Run editions, such as Microsoft Office 365 Home. (How to determine?)

Improvements and fixes

This update includes the following fixes and improvements for the Power Pivot Add-in:

  • Deletes unsupported KPI icon sets from Power Pivot.

  • Renaming a measure in the PivotTable field list will apply that change to the name in Power Pivot.

  • Fixes issues that occur when you use the option to save password for connections to SQL Server from Power Pivot.

  • Fixes issues that occur when you import data into Power Pivot from Analysis Services.

  • Enables changes to the data type of a column after you rename the column in Power Pivot.

  • Fixes issues that occur when you use column sort or filter control in Power Pivot after you add a table to the data model.

  • Improves support for DAX formula auto-complete in right-to-left languages.

  • Fixes some Power Pivot help links that point to help topics in an incorrect language.

  • Fixes issues that might occur when you use unsupported Power Pivot KPI icon sets.

  • Fixes issues that might occur when you use copy or paste operation in Power Pivot on a measure that contains a KPI.

  • Fixes the issue of the display of field names in right-to-left languages in Power Pivot diagram view after you use the drag-and-drop operation.

  • Supports correct visualization based on data type of Power Pivot column that's created by Get & Transform queries.

  • Fixes some missing localization of strings in Power Pivot.

How to download and install the update

Microsoft Update

Use Microsoft Update to automatically download and install the update.

Download Center

This update is also available for manual download and installation from the Microsoft Download Center.

If you're not sure what platform (32-bit or 64-bit) you're running, see Am I running 32-bit or 64-bit Office? Additionally, see more information about how to download Microsoft support files.

Microsoft scanned this file for viruses by using the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to it.

Update information

PrerequisiteTo apply this update, you must have Microsoft Office 2016 installed.

Restart informationYou may have to restart the computer after you install this update.

More Information

To determine whether your Office installation is Click-to-Run or MSI-based, follow these steps:

  1. Start an Office 2016 application.

  2. On the File menu, select Account.

  3. For Office 2016 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item isn't displayed.

Office 2016 Click-to-Run installation

MSI-based Office 2016

The screenshot for Word click to run

The screenshot for Word MSI

Windows 10

  1. Go to Start, enter View Installed Updates in the Search Windows box, and then press Enter.

  2. In the list of updates, locate and select KB3114517, and then select Uninstall.

Windows 8 and Windows 8.1

  1. Swipe in from the right edge of the screen, and then select Search. If you're using a mouse, point to the lower-right corner of the screen, and then select Search.

  2. Enter windows update, select Windows Update, and then select Installed Updates.

  3. In the list of updates, locate and select KB3114517, and then select Uninstall.

Windows 7

  1. Go to Start, enter Run, and then select Run.

  2. Enter Appwiz.cpl, and then select OK.

  3. Select View installed updates.

  4. In the list of updates, locate and select KB3114517, and then select Uninstall.

References

Learn about the standard terminology that's used to describe Microsoft software updates. The Office System TechCenter contains the latest administrative updates and strategic deployment resources for all versions of Office.

File Information

The global version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

excelpp-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Common.dll

Microsoft.analysisservices.common.dll

11.0.9166.158

1,564,864

16-May-2016

23:06

Backend.dll

Microsoft.analysisservices.excel.backend.dll

11.0.9166.158

1,775,816

16-May-2016

23:06

Connuidlg.dll

Microsoft.data.connectionui.dialog.dll

8.0.50727.3053

409,280

16-May-2016

23:06

Connui.dll

Microsoft.data.connectionui.dll

8.0.50727.3053

22,208

16-May-2016

23:06

Xladomdc.dll

Microsoft.excel.adomdclient.dll

11.0.9166.158

697,544

16-May-2016

23:06

Xlamo.dll

Microsoft.excel.amo.dll

11.0.9166.158

1,582,280

16-May-2016

23:06

Exceldm.dll

Microsoft.office.excel.datamodel.dll

16.0.4387.1000

310,984

17-May-2016

06:33

Sstring.dll

Microsoft.sqlserver.configuration.sstring.dll

11.0.9166.158

33,472

16-May-2016

23:06

Msmdloc.dll

Msmdlocal_xl.dll

2011.110.9166.158

60,132,544

17-May-2016

06:33

Xlmsmdsr.rll_1033

Msmdsrvi_xl.rll

2011.110.9166.158

1,133,248

17-May-2016

06:33

Msmgdsrv.dll

Msmgdsrv_xl.dll

2011.110.9166.158

7,867,576

17-May-2016

06:33

Msolap10.dll

Msolap110_xl.dll

2011.110.9166.158

9,117,888

17-May-2016

06:33

Xmlrw_xl.dll

Xmlrw_xl.dll

2011.110.9166.158

286,912

17-May-2016

06:33

Xmlrwbin.dll

Xmlrwbin_xl.dll

2011.110.9166.158

198,328

17-May-2016

06:33

Xmsrv_xl.dll

Xmsrv_xl.dll

2011.110.9166.158

25,180,856

17-May-2016

06:33

excelpp-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Common.dll

Microsoft.analysisservices.common.dll

11.0.9166.158

1,564,864

16-May-2016

23:05

Backend.dll

Microsoft.analysisservices.excel.backend.dll

11.0.9166.158

1,775,808

16-May-2016

23:05

Connuidlg.dll

Microsoft.data.connectionui.dialog.dll

8.0.50727.3053

409,280

16-May-2016

23:05

Connui.dll

Microsoft.data.connectionui.dll

8.0.50727.3053

22,208

16-May-2016

23:05

Xladomdc.dll

Microsoft.excel.adomdclient.dll

11.0.9166.158

697,536

16-May-2016

23:05

Xlamo.dll

Microsoft.excel.amo.dll

11.0.9166.158

1,582,272

16-May-2016

23:05

Exceldm.dll

Microsoft.office.excel.datamodel.dll

16.0.4387.1000

310,976

17-May-2016

06:27

Sstring.dll

Microsoft.sqlserver.configuration.sstring.dll

11.0.9166.158

33,472

16-May-2016

23:05

Msmdloc.dll

Msmdlocal_xl.dll

2011.110.9166.158

41,348,800

17-May-2016

06:27

Xlmsmdsr.rll_1033

Msmdsrvi_xl.rll

2011.110.9166.158

1,133,248

17-May-2016

06:26

Msmgdsrv.dll

Msmgdsrv_xl.dll

2011.110.9166.158

7,146,688

17-May-2016

06:27

Msolap10.dll

Msolap110_xl.dll

2011.110.9166.158

7,561,400

17-May-2016

06:27

Xmlrw_xl.dll

Xmlrw_xl.dll

2011.110.9166.158

244,416

17-May-2016

06:27

Xmlrwbin.dll

Xmlrwbin_xl.dll

2011.110.9166.158

170,176

17-May-2016

06:27

Xmsrv_xl.dll

Xmsrv_xl.dll

2011.110.9166.158

31,534,272

17-May-2016

06:27

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.