Jump to content
Business Intelligence & Analytics for Digital Transformation

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


Saurabh Jain

613 views

 

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

 

2 Comments


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.
Details:
    cd5hk2xn.XLS

can you help please

Link to comment
Guest
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...