Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation
  • Excel Tutorials

Case series 4 : Combining all files in folder and automate the combining process for new files

Saurabh Jain



Overview of using Power Query in Excel to automate the combining (appending) task Free Advanced MS Excel course



Recommended Comments

Hi team,

I am trying to combine two simple excel files just to learn this power query and getting this massage:


DataFormat.Error: External table is not in the expected format.

can you help please

Link to comment
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board
  • Create New...