Subscribe Bookmark RSS Feed

Warning message

ken_scheepers

Community Trekker

Joined:

Feb 16, 2015

I'm new to JMP. Is there a way to eliminate this message please? Perhaps a setting somewhere I have not found yet?

8217_pastedImage_0.png

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

That warning is coming from the JMP Add-in for Microsoft Excel.

It's there because transferring a large number of rows using the add-in can be time consuming. With that much data it's usually faster to use File->Open in JMP to import the Excel file directly.

Unfortunately, the threshold for this warning message is hardcoded at 10,000 rows and there's no way to avoid it.

-Jeff

-Jeff
3 REPLIES
Craige_Hales

Staff

Joined:

Mar 21, 2013

I can't find this dialog in JMP.  After the table opens, do you see an OnOpen script?  Use the red triangle to edit it and see what it does. 

8218_onopen.PNG

Craige
Solution

That warning is coming from the JMP Add-in for Microsoft Excel.

It's there because transferring a large number of rows using the add-in can be time consuming. With that much data it's usually faster to use File->Open in JMP to import the Excel file directly.

Unfortunately, the threshold for this warning message is hardcoded at 10,000 rows and there's no way to avoid it.

-Jeff

-Jeff
ken_scheepers

Community Trekker

Joined:

Feb 16, 2015

Thanks Jeff.

My process has been to create the new table using the Add-in in Excel. I will use File->Open in future.

Much appreciated.

Ken