Keeping the format when updating the spreadsheet link

[Attroll]

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?

[Attroll]

Haeme, that says it is for Google Docs and Google spreadsheets. I am not using Google Docs. I am using an excel file on my hard drive.

[Haeme Ulrich]

Ups sorry, wrong link. I meant WordsFlow

http://emsoftware.com/products/wordsflow/

[johndglobe]

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.