I have linked an excel sheet to my InDesign, and it updates perfectly with my character, paragraph, cell and table styles. But I have two issues I can't fix:
Hope someone can help.
When linking your excel file - File>Place and click Show Options
Is the table format set to Formatted or Unformatted?
Hi, sorry for the late reply. It seems I did not get any alerts on the question. It is Unformatted and then I do the formatting in InDesign - but the problem is not there anymore. Now I have a new one posted in another question today. A bit of the same, but this time with upper/lower case in Unformatted tables.
Excel view with a forced line break (after the "a") and with the code:
Thank you 🙂
I corrected my post. Excel forced line breaks (Alt-Enter) are supported.
Note: I did not test on Excel for Mac.