User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lisaash
lisaash
Level I

how do you update a jmp with excel file & not loose the formulas

Feb 16, 2026 03:48 AM (710 views)

Hello, do I update a JMP data table with data from excel without loosing the formulas? thanks

0 Kudos
4 REPLIES 4
jthi
Super User jthi
Super User

Re: how do you update a jmp with excel file & not loose the formulas

Feb 16, 2026 04:30 AM (707 views)  |  Posted in reply to message from lisaash 02-16-2026

Formulas from excel or formulas in JMP table? Are you just adding new data (concatenate) or updating existing data (update/join)?

-Jarmo
0 Kudos
hogi
hogi
Level XIII

Re: how do you update a jmp with excel file & not loose the formulas

Feb 16, 2026 10:12 AM (696 views)  |  Posted in reply to message from jthi 02-16-2026

JMP formulas.

the update script should not be called "Update". It's very misleading.

0 Kudos
hogi
hogi
Level XIII

Re: how do you update a jmp with excel file & not loose the formulas

Feb 16, 2026 10:18 AM (695 views)  |  Posted in reply to message from hogi 02-16-2026

please refer to this post for further details:
JMP 18 new Update Table script overwrites table 

lisaash
lisaash
Level I

Re: how do you update a jmp with excel file & not loose the formulas

Feb 17, 2026 08:03 AM (655 views)  |  Posted in reply to message from jthi 02-16-2026

The formulas in JMP

 

 

0 Kudos

Recommended Articles