Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: New feature updates for Power Pivot in Excel 2016

14 Mar 2016   #1
Brink

64-bit Windows 10 Pro
 
 
New feature updates for Power Pivot in Excel 2016

Quote:
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:
  • Table selection using keyboard navigation—Type the first letter of a table name to move the first column name starting with the selected letter.
  • Column selection using column navigation—Type the first letter of a column name to move the first column starting with the selected letter. Retype the same letter moves to the next column starting with the selected letter.
  • Auto column suggestion for same column name in both tables—After selecting the first table and column, on the selection of the second table, if a column with the same name exists, it is auto-selected (works both ways).
Fixes that improve your overall modeling user experience

We made a few fixes that improve your modeling user experience, including:
  • Power Pivot data model is no longer lost when working with hidden workbooks.
  • Ability to upgrade an Excel 2010 workbook with a data model to Excel 2016 is now available.
  • Ability to add a calculated column in Power Pivot, unless it contains a formula, is now available.
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:
  • KB3114374—Office 2016 Excel update from December 8, 2015.
  • KB3114297—Office 2016 Power Pivot in Excel from December 8, 2015.
Try them yourself!

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.


Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs


My System SpecsSystem Spec
.
Reply

 New feature updates for Power Pivot in Excel 2016




Thread Tools




Similar help and support threads
Thread Forum
Excel 2016 error using Round
The following formula gives the correct result for each of the conditions: - =IF(GrosInc-PAIncLmt<0,EPA,IF(GrosInc-PAIncLmt-(EPA*2)>=0,0,EPA-(GrosInc-PAIncLmt)/2)) but if I introduce the Round function: - ...
Microsoft Office
May 2017 updates for Get & Transform Excel 2016 & Power Query add-in
Source: May 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
News
Excel 2016
Hi I have been trying to find out what Im doing wrong with this. Its not .pgn data im wanting its just copy info with noation I am wanting to create an Excel 2016 searchable database for ECO Chess openings. I have tried Data>Get data > webpage. I have attached a couple of screen shots to try...
Microsoft Office
April 2017 updates for Get & Transform in Excel 2016 and Power Query
Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
News
Excel 2016: Displaying formulas in the formula bar
I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64-bit. Intel Core i7-4770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 12:34.
Twitter Facebook Google+