Reply
 
Thread Tools Display Modes
  #1   Report Post  
James
 
Posts: n/a
Default Maintaining the format of linked tables.

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
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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 :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Landscape tables in a portrait format. James Page Layout 1 January 21st 05 03:49 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Merging tables in Word 2003 JoanN Microsoft Word Help 3 December 21st 04 06:35 PM
insert a table bwtween a series of tables Series of tables Tables 2 November 9th 04 10:19 PM
Is there a way to "join" tables in Word 2003? Julian Turner Tables 3 October 28th 04 06:51 PM


All times are GMT +1. The time now is 08:58 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"