Skip to main content

Announcing smart rename support in the data model for Excel 2016

We are pleased to introduce a new Excel 2016 feature that improves the analyst’s workflow—smart rename support in the Power Pivot data model.

Now in Excel 2016, when you rename a table, column or DAX measure in the data model, the rename is seamlessly propagated through the workbook and all the affected objects in the workbook adjust to use the new name. Smart rename support in the data model significantly improves the scenarios when the user renames a table, column, calculated field, measure or hierarchy in the Power Pivot window.

Specifically, the following enhancements have been made:

  • Affected DAX calculations now adjust to use the new names. This saves the user from manually finding and fixing the invalid DAX formulas.
  • Affected PivotTables and Fields Lists now adjust to use the new names. This saves the user from manually rebuilding the PivotTables.
  • In a similar manner, the affected PivotCharts and Fields Lists adjust to use the new names. This saves the user from manually rebuilding the PivotCharts, as the renamed objects were removed from the PivotChart before.
  • And last but not least, the affected Slicers and Timelines adjust to use the new names. This saves the user from re-creating the Slicers and Timelines, as the affected Slicers and Timelines disappeared from the workbook before.

A live demonstration is better than a thousand of words, so let’s see the new experience in Excel 2016:

Smart rename support for Cube functions and Named Sets in the workbooks is not supported at this stage.

We hope that you’ll love the new experience, and we will be glad to hear your feedback.

You may also like these articles

Image for: A woman sitting on a couch using her PC laptop.

Introducing Money in Excel, an easier way to manage your finances

Today, with the launch of Money in Excel, we are embarking on a journey to simplify your day-to-day money decisions to help you stay on track of your longer-term financial goals.

Image for: A man working from home.

Get Yammer in Teams and new features in Microsoft Edge—here’s what’s new to Microsoft 365 in April

In this world of remote everything, our customers are discovering so many new ways to work and learn online. We’re committed to shipping updates and improvements to our tools that help you stay connected, productive, and secure through the current crisis and beyond.

Image for: Image of a father and daughter on a couch.

Introducing the new Microsoft 365 Personal and Family subscriptions

The subscription service for your life to make the most of your time, connect, and protect the ones you love.