You have two choices here, do all the formatting in Excel so everything
updates properly or use table and cell styles.
Without knowing all of the details, it's difficult to make a
recommendation but you might want to try the former first since it's
going to be a bit easier.
So I would need a table and cell style for each column, if I wanted the columns to be a certain width atfer the update
We have many publications with statistical tables, which are done in excel. We want to try to do some publications with only tables and do it in-house. The problem is when we place the table in indesign and finish formatting the table. We will get a updated table that needs to be updated in indesign. But when we do we update we lose all of the indesign formatting. Fixing the fonts, type size, etc is easy but how do we get back the all column widths.