This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
TriangularCurve
TriangularCurve
Level I

JMP 17 Fails to Import Excel File

Nov 22, 2023 01:36 PM (1270 views)

Hello,

 

I have an excel file I'm trying to import but I am continuously getting an error stating "There was an error opening the file" with no other information. I have read a few similar threads and none of the issues other people had seem to apply to my situation. The file is not currently opened by someone else, and it is an .xlsx file from the newest version of excel.

 

I have tried changing the import preferences to no avail. I cannot even get the excel wizard to open, it fails before that.

0 Kudos
10 REPLIES 10
TriangularCurve
TriangularCurve
Level I

Re: JMP 17 Fails to Import Excel File

Nov 22, 2023 03:47 PM (196 views)  |  Posted in reply to message from hogi 11-22-2023

I did try to save it to a different location and that didn't work. I will try splitting up the data and see if I can make it work. Unfortunately I'm trying to make a dashboard using this data for other users to access so even If i get it to work splitting it up that may not be a viable long term solution. 

 

Thanks for all the help.

0 Kudos