topic Re: problem to open excel in Discussions

problem to open excel

Françoise — Sat, 10 Jun 2023 23:25:53 GMT

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

Re: problem to open excel

Jeff_Perkinson — Tue, 09 Feb 2021 15:04:51 GMT

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: problem to open excel

Mark_Bailey — Tue, 09 Feb 2021 17:34:01 GMT

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.

Re: problem to open excel

Françoise — Wed, 10 Feb 2021 15:39:01 GMT

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