June 7, 2016, update for Office 2016 (KB3114517)

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

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.

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.