problem to open excel

[#1]

hi,

with JMP 15, I have a ne error message. I don't understand what to do.

can someone give me a solution please?

best regards

[#2]

The English translation of the error message:

Excel, Opening files created with a version earlier than Excel 97 may not be successful. In this case, choose the Open all sheets option to successfully open. 

It seems that you've tried to open an Excel file in a format that pre-dates Excel 97. If the file didn't open successfully you may find the Open All Sheets preference helpful.

You'll find this preference from File->Preferences... and the Third-party Data section.

 

@briancorcoran explained why this may be necessary in RE: Error Opening Excel File. 

[#3]

 Hi,

with my Jump (15.2.1), I have no problem to open and you can see my prefernces : excel in the screen image.

the file is an excel office 365 . xlsm.

I shall verify the preferences for the others JMP (there is this problem for 2 colleagues who have JMP 15).

best regards

[#4]

Another idea, depending on where your analysis starts, is to open the original workbook in a newer version of Excel and save it again before importing it in JMP.