updating linked table without loosing the design

Community Beginner ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

I placed a linked Excel Table to InDesign.

I used table style, character style and Cell style to save the design of the table every time I update the link.

I created a different style to the table header.

When I update the link all formatting settings are saved except the setting of character style.

How to fix it?

Views

180

Likes

translate

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
Most Valuable Participant ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

Screenshots might help but all styles must be defined in the cell and table styles. You cannot define a character style and have it stick by itself.

Likes

translate

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 ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

I try to set a font color, the font color changes each time I update the tables

Likes

translate

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 ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

Set a different text color only in the header

Likes

translate

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
Most Valuable Participant ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

Do you have a cell style with that character style assigned to it?

Likes

translate

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 ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

IMHO, you need to try Woodwing SmartStyles for such tasks. Yep, I know about the price.  It's worth it when you have many tables in work.

Smart Styles - Adobe InDesign plugin | WoodWing Software

Remember, never say you can't do something in InDesign, it's always just a question of finding the right workaround to get the job done. © David Blatner

Likes

translate

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
Most Valuable Participant ,
Feb 20, 2019 Feb 20, 2019

Copy link to clipboard

Copied

The huge benefit to SmartStyles is that it maintains cell insets and sizes. So, yeah…with lots of tables it’s a time saver for sure.

Likes

translate

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 Employee ,
Feb 21, 2019 Feb 21, 2019

Copy link to clipboard

Copied

Hi Louise,

Sorry to hear about this issue. I would request if you can share a few more details like:

Few screenshots or a small video of the issue.

OS(Exact version of Windows/MAC) and version of InDesign?

Is it happening with a particular file or multiple files?

Regards,

Srishti

Likes

translate

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 ,
Jan 12, 2021 Jan 12, 2021

Copy link to clipboard

Copied

I am having the same issue. When I update a linked Excel table in Indesign I lose the formatting that I had applied on previous tables. Is there a way around this?

Likes

translate

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
Most Valuable Participant ,
Jan 12, 2021 Jan 12, 2021

Copy link to clipboard

Copied

What was unclear about what's already been posted here?

Likes

translate

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