At the risk of blasphemy, I am trying to figure out how to save a table that has hyperlinks for all data in a column in an Excel file, where the hyperlinks are still functional. I pull a lot of Excel data into JMP for faster data analysis and can add hyperlinks to entries in JMP columns. I can save the resulting charts as picture files and raw data files that can be read in Excel, but would also like to save the data table in Excel format with the hyperlinks preserved, so that non JMP users still can use the links...
Is there a way to do this easily without needing to invoke VBA after the file is saved? I am trying to automate this within JMP, if at all possible.
I tried to save a JMP table in XML format to see if it would preserve links, but that does not appear to be an option.
If this is not possible now, can this be added in JMP17?
Thank you,
Jens
