Is there a way to tell JMP not to recalcualte an excel sheet when it opens, or to ensure that the calculated values are available before saving the excel file?
A common problem for users who import data into excel via a third-party add-in is an apparrent inconsistency in whether the calcualted values are correctly imported into JMP. Sometimes the values are imported as expected, and sometimes the data table is filled with '#NAME?', which is the same error Excel returns if the Add-in is disabled. I assume that the Excel file is being re-calculated when JMP opens it, and at that time the add-in is not avaialble or is not fast enough.
I was able to replicate this problem by making a custom vba function in an add-in that returns a value stored in code. Add a few cells that reference that function and save the sheet, then open it in JMP. Unload and reload the excel add-in and save the sheet. One day it opens fine and a week later it returns #NAME? instead.
