Keeping the format when updating the spreadsheet link

Forum|Forum|9 years ago
January 20, 2017
返信数 4.
9465 ビュー

I have imported a spreadsheet to my InDesign and linked it.

I love this option.

I edit the spreadsheet in excel and save it.

Then when I open my InDesign, it ask me to update the link.

I click UPDATE LINKS, and it does update the spreadsheet in my document.

However my formatting that did earlier to the spreadsheet inside of InDesign is gone.

I am referring to cell spacing.

Is there a way to retain that so that I do not have to fix that ever time I update the link?

このトピックへの返信は締め切られました。

johndglobe

Participant

Hello,

I had a similar issue. I have a file with 13 different linked ranges through 175 different pages. It helped greatly when I used Named Ranges in the excel file. It is weird but when you name the range in the excel file, and then when linking show Import Options. Then make sure that you select the named range as opposed to defining the correct range in the dialogue box. Then when you update the contents of the named range the contents update but it keeps the formatting previously assigned in indesign as long as the formatting is assigned as a cell style. But the exception (there is always an exception) is when you change the size of the named range, you have to relink using the named range.

I just wanted to throw this out there. I am by no means an expert but this is what I found. Maybe the experts can look into my explanation and understand why this happens. I have no idea why, i just know that it works.

Haeme Ulrich

Inspiring

Another strategy (other than Table and Cell Styles) would be to use an InDesign Plugin. I would use DocsFlow Pro. With it you can update linked Excel Files very easy without loosing the InDesign styling:

http://emsoftware.com/products/docsflow/