I am not sure if this is a JMP or Excel issue (or both). I often have to share my data tables with non-JMP users. I frequently save the JMP data table in Excel format and do this with a number of data files which I then create copies of individual worksheets and move them all into one workbook. In the past (up to a couple of months ago), this worked fine. All of a sudden, every Excel workbook I save from a JMP data table is now protected. There is no password protection but I am unable to rename or move any worksheet from one workbook to another. I have tried but found no way to unprotect these workbooks. I have tried saving the data files as text files or .xls format, but every time I open it in excel, it shows up as a protected workbook with no way to unprotect it.
I am running JMP 17. This feels like a Microsoft update issue, but I have not been able to figure out where the problem is coming from. I don't see any JMP options for protecting (or not) data tables saved in other formats. And, as I said, this problem has suddenly emerged after not being a problem in the past. Anybody have any ideas?