Issues when you use import and transformation features in the Get & Transform section of the Data tab in Excel 2016

Symptoms

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.

Resolution

To fix these issues, install update MS15-116: Description of the security update for Excel 2016: November 10, 2015 (KB3101510).

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×