Error - Importing excel (365)Hello,
I'm trying to import excel (365) file, and I can't do it.
I'll mention that until I've updated the Office to 365 everything worked fine.
Someone's having a similar problem or someone has a solution?
Open(
"C:\Desktop\namefile.xlsx",
Worksheets( "Sheet1" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 2 ),
Data Starts on Row( 3 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 0 ),
Replicated Spanned Rows( 1 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Treat as Hierarchy( 0 )
);
Thx
Re: Error - Importing excel (365)Hi,
I tried to import the Excel file in JMP 11 and it didn't work,
but I tried to import the same file in JMP 14 and it works! 
I don't know what the problem was but it works.
Thx to all for the support.
Re: Error - Importing excel (365)I think you may need to contact JMP Technical Support.
Re: Error - Importing excel (365)Hi Dan,
Yes, it's an Excel file.
The file is closed and it still doesn't work.
Re: Error - Importing excel (365)Just a thought: is the file still open in Excel? If so, close out of Excel. Maybe that would fix it?
Re: Error - Importing excel (365)hi Jeff,
yes, I getting an error message.
see attached.
Re: Error - Importing excel (365)Are you getting an error message? What happens when you try to import the file?
