How to retain formatting of tables

[Guest]

I am also having problems formatting linked Excel tables in Word. I
originally pasted the Excel table using Word's paste special option with the
paste link and RTF options selected. I have the appropriate service pack.
The merge format switch appears when the preserve formatting after update box
is checked. However, each time the link is updated the contents of the first
cell span across A1 & B1. What was in B1, C1, ect. all shift over one
column. Rows 2, 3 ect. all remain as they were. It is just the first row in
the Word doc that is affected. The Excel file remain intact.

I want to be able to format the Excel tables in Word and retain the link to
Excel so that data changes in Excel update to Word. Is there anyway I can do
this without reformatting my tables each time I update the links?

Thanks!

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGFtbWllIENhcmlubw==?=,

How does the original data in Excel look, in this first row? What does cell A1
contain, exactly?

If you change the \r switch in the field code to \h (HTML rather than RTF
format) do you get anything different?

I am also having problems formatting linked Excel tables in Word. I
originally pasted the Excel table using Word's paste special option with the
paste link and RTF options selected. I have the appropriate service pack.
The merge format switch appears when the preserve formatting after update box
is checked. However, each time the link is updated the contents of the first
cell span across A1 & B1. What was in B1, C1, ect. all shift over one
column. Rows 2, 3 ect. all remain as they were. It is just the first row in
the Word doc that is affected. The Excel file remain intact.

I want to be able to format the Excel tables in Word and retain the link to
Excel so that data changes in Excel update to Word. Is there anyway I can do
this without reformatting my tables each time I update the links?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail