Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!