Aug 01, 2019. Join Curt Frye for an in-depth discussion in this video, Changing the data field number format, part of Excel for Mac 2016: Pivot Tables in Depth.
We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.
Save relationship diagram view as picture
Excel 2016 users can now save the data model diagram view as a high resolution image file that can then be used for sharing, printing or analyzing the data model. To create the image file, in the Power Pivot add-in, click File and then select Save View as Picture.
![]() Enhanced Edit Relationship dialog creates faster and more accurate data relationships
Excel 2016 Power Pivot users can now manually add or edit a table relationship while exploring a sample of the data—up to five rows of data in a selected table. This helps create faster and more accurate relationships without the need to go back and forth to the data view every time you wish to create or edit a table relationship.
We have also added several usability goodies to the Edit Relationship dialog:
Fixes that improve your overall modeling user experience
We made a few fixes that improve your modeling user experience, including:
For a full list in this customer update, visit Power Pivot and the Analysis Services Engine in Excel 2016 fixes.
For all Excel 2016 users, get the latest customer update by installing the following updates. Note, there are 32- and 64-bit versions of each, so be sure to download the right version:
![]()
Try them yourself!Powerpivot Addin Download 2016
Try these new improvements and see how they can help you improve your analysis performance. Do you have ideas on other improvements that you’d like to see in Excel? Visit the Excel UserVoice and tell us about them.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |