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).

Need more help?

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

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!