Cannot open Excel 2 worksheet with error "External table is not in the expected format"

Question

Dear All,

We have a problem on importing an excel file into Alteryx.

We had the "Access 32-bit 2010 driver" already installed on the machine.

Still, when we reading into one of hIt says "External table is not in the expected format".

We checked on the file, which is in Excel 2 worksheets and in protected view.

Is that Excel 2 worksheets is not a compatible format for Alteryx to read in?

Or any other workaround could be used to open this up?

Thanks much in advance

bevankwong · Answer

Dear @mceleavey I am basically just adding the file in, and the prompt is showing like that.....

mceleavey · Answer

@bevankwong ,

are you getting the error when you try to select a range or when you simply try to import the sheet?

bevankwong · Answer

Hi @mceleavey

Unfortunately we cannot make it out for further test, so we cannot provide it out.

But is there any knowledge on version of Excel that cannot support by Alteryx / JET engine?

Cheers,

Bevan