Subscribe Bookmark RSS Feed

Data refresh from Excel file using JMP

kiza

Community Trekker

Joined:

May 8, 2012

So I have an Excel file in some sharepoint that is updated weekly, i do control charts with it and I know how to connect to it and do an SQL query to filter data. The problem is that I have some formulas in columns and whenever I run this process a new table is created (without those extra columns), is there a way to just refresh the data on the current table? That way the extra columns with the formulas are updated

Thanks