Excel Tables as Links in Word 07

[parkman]

i have a word document with several excel tables as links, so that i can
easily update the data.
however i face a very annoying problem. each time the data gets updated (be
it manually by clicking update in the menu or automatically when opening the
document, after some data was changed in the excel file) the formatting gets
lost. is there a way to solve this?

 

[Pamelia Caswell via OfficeKB.com]

What formatting is lost? How are you pasting, as formatted text (RTF) or HTML?


Pam

 

[macropod]

Hi parkman,

Whatever formatting is being lost is because someone has tried to override the format in which the data are obtained via the link.
The only reliable way to apply a particular different format to the data is via a Charformat switch - which will apply that format
to the whole of the linked data. Thus, if you need different formats for different portions, you might consider using separate links
for each and applying the Charformat switch accordingly. See Word's Help file for more details.

Alternatively, apply some suitable Style names to the various ranges in Excel and format those Styles appropriately in Word.