Forum Discussion

Mariano_bomfim17's avatar
Mariano_bomfim17
Copper Contributor
Mar 27, 2024

Combine, load and transform options do not appear in Excel

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:

 

 

 


Screen displayed:

 

 

2 Replies

  • Mariano_bomfim17 

    Desired screen is for the connection to the selected file.

    Screen displayed is when you select From Folder connector.

    Please note as well, on 2016 is outdated version of Power Query, interface could be slightly different.

    • Mariano_bomfim17's avatar
      Mariano_bomfim17
      Copper Contributor


      SergeiBaklan, agradeço o retorno, no entanto, eu fiz esse procedimento com uma pasta com vários arquivos, e aparecia essa tela desejada. Eu já havia tentado configurar nas outras máquinas da área e apenas a minha aparecia  essa tela desejada fazendo o mesmo processo, as outras máquinas estavam indo diretamente para a tela exibida.
      Não sei se há alguma configuração ou extensão necessária, estou pesquisando ainda.

Resources