Excel.Workbook failure

[Reuven83]

Hi 

I have a query that contacts few excel files. The first step is Excel.Workbook(File.Contant(file path)) 

the secont step is to navigate to the column "Data" where Item = "Financial " and  Kind = "Table". (the name of the table is Financial) .

it worked petfect and works for most of the files.

But for one file, the File.content returns only two columns with Name and Data.  as a result, the next step failed. 

What causes it and how to fix it? 

Thank you. 

[Anonymous]

Is it an .xls file? If so, save it as .xlsx

--Nate

[Omid_Motamedise]

can you share the file or the steps on your query?

[ronrsnfld]

And what is the content of the two columns?  What is the structure of the errant workbook?

[Greg_Deckler]

@Reuven83 Are there perhaps some hidden columns in that one file that might be messing things up? Would really have to share the files in question to see what the difference might be.