Jump to content


Photo

Version 1705 - Jun 7, 2017 - Retain copy fix, Get & Transform improvements


  • Please log in to reply
No replies to this topic

#1 Mike

Mike

    Advanced Member

  • Administrators
  • 190 posts

Posted 20 July 2017 - 11:39 AM

Version 1705 (Build 16.0.8201.2075)

 

Released to Current Channel on Jun 7, 2017

 

Retain Copy fix

 

Copy and  Paste has been improved.  Previously if you copied and then did other tasks (like typing or inserting cells) the copy was lost and the clipboard cleared.  This has now been fixed.

 

Data tab re-designed

 

The data tab now has two new groups: Get & Transform Data and Queries & Connections.

 

Get & Transform Queries can now be shared

 

You can now export a query into an Office Database Connection (ODC) file and then share it across workbooks or with others.

 

Get & Transform Load Data command

 

Load Data can now send query data directly into Pivot Tables or Pivot Charts without having to first save the data into the Data Model.

 

Get & Transform improvement

 

In the Query Editor, if you create a new column by providing sample values,  as you type, Excel detects the required transformations and shows a preview of the new column.

 

 

Queries can now be shared

 

You can now export a query into an Office Database Connection (ODC) file and then share it across workbooks or with others.


Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users