Skip to main content
Skip to main content
Microsoft 365

Power Pivot in Excel 2013—November 2015 customer update

The November Power Pivot for Excel 2013 update delivers a better experience when using Power Query with Power Pivot as well as support for Key Performance Indicators (KPI).

These fixes are delivered as part of following updates (there are 32- and 64-bit versions of each):

  • KB3039739—Update for Office 2013, which includes the first part of the Power Pivot and Power Query working better together fix.
  • KB3039800—Update for Office 2013, which includes the second part of the Power Pivot and Power Query working better together fix; the issue will not be resolved if you install just one of these patches.
  • KB3085502—MS15-099 security update for Excel 2013, which enables single sign-on (SSO) for ADAL on cloud domain-joined computers, respecting additional icon sets for a KPI in Power Pivot and several other fixes.

Using Power Query with Power Pivot

For data in Power Pivot that has been added through Power Query, the following operations can now only be done through Power Query, which resolves conflicts previously seen in Power Pivot.

  • Edit Table Properties
  • Column-level changes: Rename, Data type change, Delete
  • Table-level changes: Rename, Delete

A detailed KB article on the subject can be found here, and the scenario is outlined below:

  1. Using Power Query, import your data from a data source of your choice.

Power Pivot in Excel 2013 1 - 1

2.  Once your Power Query data manipulations are complete, select Close & Load To…

3.  When prompted, select Add this data to the Data Model and then click Load.

4.  Next, open the PowerPivot window, select a column on the table you just loaded using Power Query and rename that column. The same will apply to delete column, delete table and edit table as mentioned above.

5.  An attempt to rename a column in the model created with Power Query is blocked with a message that data originated in Power Query should be updated in Power Query; doing this prevents conflicts between the two tools.

Power Pivot in Excel 2013 5 - 5

KPI support

Power Pivot allows customers to define KPIs with various settings such as the target value, icon styles and KPI description.

Power Pivot in Excel 2013 6

The Excel 2013 update for KPIs includes:

  • Additional icon sets for a KPI status, including five levels of icon sets.
  • Alignment with the absolute KPI target value data type with that of the type of the measure. As a result, both Value and Goal measures now show the same data type on a PivotTable.

We hope these updates will increase your analysis productivity with Excel! If you have suggestions or feedback, visit Excel UserVoice.

You may also like these articles

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.

Connect to your own data with more new data types in Excel

The evolution of Excel Excel is the ultimate decision-making tool. We’re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base…