Skip to main content
E
Elisabete Pereira
Inspiring
April 4, 2022
Answered

Excel - Update in Indesign and keep styles

  • April 4, 2022
  • 1 reply
  • 1099 views

Hello!

I'm trying to import an excel sheet to Indesign so I can update data in Excel and automatically get uptdated in Indesign. I read some topics here and I already get to import a table keeping the style (with the import options). I also read that to be able to update data in Indesign I had to import the table with no format, but, when I do that and change in the Excel, it does appear any alert about the changes and does not update the data in Indesgin. Can you help to understand what i'm doing wrong? Thank you! BR, Elisabete

This topic has been closed for replies.
Correct answer jmlevy

Do it without any opened document. Quit and relaunch.

1 reply

jmlevy
Community Expert
jmlevyCommunity Expert
Community Expert
April 4, 2022

Did you tick this checkbox in the preferences?

I also read that to be able to update data in Indesign I had to import the table with no format

It is not exactly that: you can import a formatted table, but if you modify the format in InDesign and then, if you change the data of the Excel file, you will loose the local InDesign format modifications.

    E
    Elisabete PereiraAuthor
    Inspiring
    April 4, 2022

    Hi!

    Thank you very much for your help and quick reply.

    In fact, the problem it was exactly that check box. Now it's working perfectly. 

    And thanks for the clarification about the styles and formats.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices