Combine, load and transform options do not appear in Excel

Mariano de Jesus Bomfim 0 Reputation points
2024-03-27T19:55:58.5433333+00:00

Load, combine and transform options do not appear in my Excel 2016 when selecting a folder with several files, how do I choose these options?

Before these options appeared, on my machine, it was the only one in the area that appeared, I need to format it and it no longer appears...

When you click OK, after selecting the folder with the files, the Query Editor opens directly and the options do not appear, can anyone help me?

Desired screen:Tela desejada

Screen displayed:

tela exibida II

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,425 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 4,285 Reputation points Microsoft Vendor
    2024-03-28T06:15:22.4733333+00:00

    Hi @Mariano de Jesus Bomfim

    I test Excel for Office Professional Plus 2016, there are no such options when getting data from a folder.

    Here is a video: https://youtu.be/rSQwZ1d3b1g , you may import multiple Excel files according to it.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.