Excel - Update in Indesign and keep styles

Community Beginner ,
Apr 04, 2022 Apr 04, 2022

Copy link to clipboard

Copied

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

TOPICS
How to

Views

76

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Adobe Community Professional , Apr 04, 2022 Apr 04, 2022
Do it without any opened document. Quit and relaunch.

Likes

Translate

Translate
Adobe Community Professional ,
Apr 04, 2022 Apr 04, 2022

Copy link to clipboard

Copied

Did you tick this checkbox in the preferences?

Capture d’écran 2022-04-04 à 11.43.20.jpg

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 04, 2022 Apr 04, 2022

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 04, 2022 Apr 04, 2022

Copy link to clipboard

Copied

Is there any way to keep that checkbox selected? Because everytime I close InDesign and reopen it I have to tick that option again.

Thank you!

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 04, 2022 Apr 04, 2022

Copy link to clipboard

Copied

Do it without any opened document. Quit and relaunch.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 04, 2022 Apr 04, 2022

Copy link to clipboard

Copied

LATEST

Perfect! Thanks again. 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines