Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Cannot combine binary files or extract table

I am trying to combine around 1000 excel workbooks. However, It does not get combined due to some error which I don't know.    Then I try to add custom column and write Excel.Workbook([Content]) an...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello, I found a soultion. The files had some errors in it (files arrived through an automated system in excel 97-2003 version). But when I open and save the file in excel, the error disappeared and appeared as table in PowerBI and could combine all.

     

    So I opened and saved all in mass with a Macro. Now all is OK.

     

    Thanks  you anyway.

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share a couple of sample workbooks which are showing an error in the Custom column.  Please ensure the file sizes are small.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello, I found a soultion. The files had some errors in it (files arrived through an automated system in excel 97-2003 version). But when I open and save the file in excel, the error disappeared and appeared as table in PowerBI and could combine all.

 

So I opened and saved all in mass with a Macro. Now all is OK.

 

Thanks  you anyway.