Video shows how to update a JMP data table to reflect Excel updates. Because JMP is intended to be hands on & generally doesn’t encourage automation, you go back to JMP to re-run the script again. Note: when you run the script in JMP, it will not copy over the Control Chart script or any other scripts you have saved in the Tables Panel, so you may want to append that to the Source script. A more automated sequence would involve scripting using JSL.
Here are some Scripting Resources: