Word losing formatting when a linked Excel named range updates

[Martynas Brijunas]

Hi everyone,

I have a list of bulletpoints in Word which draws the content from a
named Excel range. All bulletpoints are assigned a dedicated
Bulletpoint style.

The link is defined as "Unformatted unicode text".

Whenever I shrink and subsequently expand the named range in Excel,
something strange happens in Word. All the values are updated,
however, the formatting is repeatedly lost near the bottom of the
list. A part of the bulletpoint list becomes part of the Normal style.

Has anyone else come across this problem? Is there anything short of
re-applying the formatting manually or by macro that can help me. The
"Preserve formatting after update" is selected in the link options.

Thank you.

Best regards,
Martin

 

[Adam C]

I'm having a very similar problem with updates to a linked spreadsheet in
html format. The "preserve formatting after update" seems not to work at
all; whenever the link updates, all of the column sizing, etc that I have
entered for the table in the word document is undone. The table tends to
balloon off the page. If "preserve formatting" is unchecked, it also
replaces the formatting with each update, but in a slightly different way.

This is driving me crazy, as it is preventing me from doing the very thing
that this feature is designed for: editing a budget in Excel and having the
changes update themselves in a formatted budget document in Word. If you
can't preserve the formatting, there's no point to linking a spreadsheet to
Word at all!