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]) and I get the following:

 

Some are Table, the rest are ERROR. 

All excel workbooks I am trying to import have same format.

Due to this Error, I cannot Combine and Edit the binary upon Import.

 

When I double click in the Error. I get the folloing message, but the workbook is correctly in excel format.

 

Thanks for support!

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.

     

     

2 Replies

  • 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.