How to update some values in an In Design table from an EXCEL file ?

Hi Thierry,

if you want to place and link an Excel file, make sure that the table sits in its own story.

Otherwise any update of the link will remove all text around the linked table.

If you want to go one step further you can redo all or some of the local formatting of an linked and updated table with a plug-in like Woodwing's Smart Style. See into it, there is a free trial for 30 days:

https://www.woodwing.com/en/smart-styles-adobe-indesign-plugin

It always depends on how many tables you have and how often data will change if this workflow is cost effective.

Copy a column from the Excel file, selecting the first cell of your InDesign column and paste the new data is also a method. It may be a bit more time consuming, but its the most cost effective method if you do not account for your own time.

Other things to consider:

If you want a full automation process you could hire a scripter to write you ExtendScript code that is able to make changes to the table if necessary if you open your InDesign document. Just a thought…

Regards,
Uwe Laubender

( ACP )

You must have linked the Excel files before having imported it in the InDesign file, by ticking this preference:

but you have to know that you will loose any local formatting that you have made in InDesign on the table (cell color, font, type size, stroke color). So before updating your table, create cell styles, table style and so on…