Forum Discussion
reformat.Error: External table is not in the expected format. While connecting to xlsb file.
Hello, I am try to query a data using Power Query from a SharePoint folder which contains a Excel file in XLSB format. When i try to click on the Binary and expand the below error comes up: D...
I had tried both the connector.
In this case the issue was the sheets are locked. When the sheets were unlocked it worked fine.
Regards
sabari K
How do you unlock the sheets?