Maintaining the format of linked tables.

[James]

Maintaining the format of linked tables.

I have a linked table in Word to an Excel spreadsheet, I format the
table in Word 'Table Properties' with the following commands,
Table tab 'Alignment - Center'
Row tab 'Repeat as header row at the top of each page'

I then close and save the document, but when I reopen the Word document,
the format of the table reverts back to the original inserted format. Is
there any way around this?

I am running Office 2000.

Thanks in advance for any help.

Kind regards

James

 

[Cindy M -WordMVP-]

Hi James,

A bit late... don't know why I didn't pick up on this earlier.

1. Some kinds of formatting are never retained when a table is linked in
from an outside source

2. The \* Mergeformat switch must be in the LINK field code in order for
any formatting to be retained. Alt+F9 toggles field codes on/off.

3. This switch was broken (didn't work) in the original release of Word
2000, but was fixed in a later service pack (1 or 2, can't remember which
for sure).

Maintaining the format of linked tables.

I have a linked table in Word to an Excel spreadsheet, I format the
table in Word 'Table Properties' with the following commands,
Table tab 'Alignment - Center'
Row tab 'Repeat as header row at the top of each page'

I then close and save the document, but when I reopen the Word document,
the format of the table reverts back to the original inserted format. Is
there any way around this?

I am running Office 2000.

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