Excel Add-In Data Table Name in Excel 13

Question

I've used the JMP Excel add-in for quite some time, but I've started having problem with the data table name in JMP 13.  Before I upgraded, when I used the add-in to create a JMP data table from an Excel spreadsheet, the JMP table would be named  with a combination of the Excel file name and sheet name.  Now the JMP table is named "Untitled".  I checked my preferences in the add-in, but the field is empty.  After reveiwing the Using JMP chapter dealing with the add-in, I went back to preferences and changed "Data Table Name" from blank to "File Name_Worksheet" and now my data tables are all named "File Name_Worksheet".  How can I get the add-in to create a data table with the actual file name and worksheet?  Can I further customize this so that it defaults to just the worksheet name?

Thanks!

TJ_Mills · Answer

I am on JMP 13.2.1 and having the issue of the table name created as "Untitled". If I use the suggestion of typing &[File]_&[Tab] in the preferences for file name. It changes the preferences to that file name for all future saves including other files. This causes other tables to be named incorrectly.

I think this is still a bug in 13.2.1? Anyone else seeing this?

TSchemme · Answer

Happens to a lot of us.

&[File]_&[Tab]

Is what you type in, and it will save in that Preferences file.

L3ph7Y · Answer

Have you tried using the following in the excel preferences box:

&[File]_&[Tab]

I had the same issue and that seems to be working for me.