I currently link an excel table into an InDesign document and while the table values update without problem, I find that i lose the formatting. This is an issue as several values in the excel table are underlined and/or highlighted in various colours. Does anyone know of a way in which i can preserve the formatting when linking an excel table into InDesign?
1. Do all the formatting in Excel and place as a formatted table.
2. Use table and cell styles and place as an unformatted table.
FWIW, I always use number 1.