"The input couldn't be recognized as a valid Excel document."

Such alert could appear when you try to use Power BI connector on Excel file. It's understandable if the source file is corrupted and can't be opened in Excel. However, it looks strange if Excel open...

BI & Data Analytics

Get & Transform Data

Anonymous

Apr 20, 2017

I have this error but it seems to be computer specific, or more accurately Excel version specific. Using the same source files, a Power Query | Combine Binaries will work from one computer but not another.

Using Excel 365 ProPlus version 1701 build 7766.2071 (First Release for Deferred Channel) it works fine.

Using Excel 365 ProPlus version 1609 build 7369.2127 (Deferred Channel updates) I get the "The input couldn't be recognized as a valid Excel document." error. Updated from Current Channel to version 1702 build 7870.2038 and the Combine Binaries worked without error.

Scope: Combine Excel rows from multiple similarly formatted excel sheets into one.

Copper Contributor

Oct 03, 2020

this error is specific to excel 2016 whereas i did not observe the same in excel 365.

Any suggestions?

Forum Discussion

"The input couldn't be recognized as a valid Excel document."

Resources