Issues when you use import and transformation features in the Get & Transform section of the Data tab in Excel 2016
When you use import and transformation features in the Get & Transform section of the Data tab in Microsoft Excel 2016, you experience one of the following issues:
- The Query Editor isn't displayed correctly on computers that have Internet Explorer installed.
- Assume that you edit a query that's previously loaded to a table and then you delete a column in the Query Editor. After the query is refreshed, a blank column is created at the end of the table.
- When you refresh a query, the focus is moved to the sheet of its associated query table.
- After you import an Excel workbook, incorrect results are displayed if a table contains blank columns.
- When you check many tables in the Navigator pane, Excel 2016 may crash.
- When you select a function in the Sparklines section in Quick Analysis of query tables that are created by Get & Transform queries, an unexpected error occurs.
- After you perform a cut-and-paste operation in a query table that's loaded by using a query, you can't refresh the query by using the Workbook Queries pane.
- When you try to delete the data source for the current workbook, an unexpected error occurs if the workbook is protected.
- When you record a macro for a query creation, a compilation error occurs.
- After several iterations, repetitive macro recording of query creation fails.
- VBA Queries.FastCombine doesn't apply to all scenarios.
To fix these issues, install update MS15-116: Description of the security update for Excel 2016: November 10, 2015 (KB3101510).
Article ID: 3108701 - Last Review: 11/10/2015 18:45:00 - Revision: 1.0
- kbqfe kbsurveynew kbexpertisebeginner kbbug kbfix kbtshoot KB3108701