I Cant Combine xlsx files from the same sharepoint folder

[AndreDeLuca]

Hello,
There is a folder on a sharepoint site that holds information of sales for every week. So every week a new file is uploaded to the folder and the idea is for the files on the folder to be automatically combined to 1 big table as they are uploaded, i already do this on the local folders of my computer and it works perfectly. But when i try to do this with a folder on share point, only the sample file is successfully transformed into table, the others appear as error. Sorry for bad english hope you can help.

Only have 4 files right now. And as you can see, only the file i choose as sample was successfully transformed, if we can figure out why the other files dont work, i believe we solve the problem

After the expand tables step this is what it looks like, it expanded only the sample file and where the other files data should appear we only see error

This is the error

[christinepayton]

It would help to know what the error is that you are receiving - if you click on eof the error cells you should be able to get the error message?