Word table loses formatting after updating linked Excel spreadshee

I've run into an issue with pasting from Excel 2007 into a Word 2007
document, using the "link" paste paste special option and pasting as RTF. For
the most part it comes in to Word great, but since it spans several pages, I
like to have the top line or lines "repeat as header" lines on each page. No
problem, I can go and modify the table in Word the way I like it.
The problem comes when the Excel spreadsheet changes and I want to update
the link in Word. All the formatting I have made to the table, such as header
lines, keep with next, unchecking the default "allow line to break across
pages", go away when I update the link. This happens whether or not I have
checked the "preserve formatting after update" in the Links configuration
editor.
Any suggestions?
Thanks,
Chris

Hi cvarner,

What you could do is:
1. create a two-row table in Word.
2. Format the first row with the required columns & headings and with the 'heading rows repeat' attribute.
3. Format the second row so that it consists of just a single cell
4. Paste the link into the second row.
That will get you the repeated heading rows on each page, though there'll probably be an unavoidable gap between the heading row and
the first linked row..

For the various 'keep with next' rows, you may be able to achieve what you're after by applying a suitable Style name to the cells
*in Excel*, then creating a corresponding Style in Word with the 'Keept with Next' attribute applied.

--
Cheers
macropod
[Microsoft MVP - Word]


"cvarner" wrote in message ...
I've run into an issue with pasting from Excel 2007 into a Word 2007
document, using the "link" paste paste special option and pasting as RTF. For
the most part it comes in to Word great, but since it spans several pages, I
like to have the top line or lines "repeat as header" lines on each page. No
problem, I can go and modify the table in Word the way I like it.
The problem comes when the Excel spreadsheet changes and I want to update
the link in Word. All the formatting I have made to the table, such as header
lines, keep with next, unchecking the default "allow line to break across
pages", go away when I update the link. This happens whether or not I have
checked the "preserve formatting after update" in the Links configuration
editor.
Any suggestions?
Thanks,
Chris

You can create a new table style, or modify the table grid table style, with
the header row settings you want, make it the default table style for new
tables in the document, and apply the style to your linked table. After
that, when update link generates a new table, it should have your header row
settings.
Note that for the heading row settings to take effect, the header row
checkbox on the table design tab must be checked.

Pam

cvarner wrote:
I've run into an issue with pasting from Excel 2007 into a Word 2007
document, using the "link" paste paste special option and pasting as RTF. For
the most part it comes in to Word great, but since it spans several pages, I
like to have the top line or lines "repeat as header" lines on each page. No
problem, I can go and modify the table in Word the way I like it.
The problem comes when the Excel spreadsheet changes and I want to update
the link in Word. All the formatting I have made to the table, such as header
lines, keep with next, unchecking the default "allow line to break across
pages", go away when I update the link. This happens whether or not I have
checked the "preserve formatting after update" in the Links configuration
editor.
Any suggestions?
Thanks,
Chris

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200911/1

Hi cvarner,

An alternative for the header row is to create a table (linked or otherwise) for it in the page header, then link the remainder of
the table in the body of the document.

Naturally, this depends on having a page layout that is amenable to having the table start at the top of the first page it appears
on. Section breaks can be used to prevent the table header appearing on previous/subsequent pages in the document.

--
Cheers
macropod
[Microsoft MVP - Word]


"macropod" wrote in message ...
Hi cvarner,

What you could do is:
1. create a two-row table in Word.
2. Format the first row with the required columns & headings and with the 'heading rows repeat' attribute.
3. Format the second row so that it consists of just a single cell
4. Paste the link into the second row.
That will get you the repeated heading rows on each page, though there'll probably be an unavoidable gap between the heading row
and the first linked row..

For the various 'keep with next' rows, you may be able to achieve what you're after by applying a suitable Style name to the cells
*in Excel*, then creating a corresponding Style in Word with the 'Keept with Next' attribute applied.

--
Cheers
macropod
[Microsoft MVP - Word]


"cvarner" wrote in message ...
I've run into an issue with pasting from Excel 2007 into a Word 2007
document, using the "link" paste paste special option and pasting as RTF. For
the most part it comes in to Word great, but since it spans several pages, I
like to have the top line or lines "repeat as header" lines on each page. No
problem, I can go and modify the table in Word the way I like it.
The problem comes when the Excel spreadsheet changes and I want to update
the link in Word. All the formatting I have made to the table, such as header
lines, keep with next, unchecking the default "allow line to break across
pages", go away when I update the link. This happens whether or not I have
checked the "preserve formatting after update" in the Links configuration
editor.
Any suggestions?
Thanks,
Chris