Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
cvarner cvarner is offline
external usenet poster
 
Posts: 3
Default 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

  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Word table loses formatting after updating linked Excel spreadshee

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


  #3   Report Post  
Posted to microsoft.public.word.tables
Pamelia Caswell via OfficeKB.com Pamelia Caswell via OfficeKB.com is offline
external usenet poster
 
Posts: 468
Default Word table loses formatting after updating linked Excel spreadshee

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

  #4   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Word table loses formatting after updating linked Excel spreadshee

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



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
Table loses formatting jen_writer Tables 4 October 20th 08 05:18 PM
Updating number of rows in linked excel object DoubleZ Microsoft Word Help 3 July 26th 08 12:25 AM
Merge from excel loses formatting Craig Mailmerge 3 February 24th 06 04:21 PM
Merge loses "symbol" character when taken from an excel spreadshee Frustrated Mailmerge 4 April 5th 05 05:50 PM
Linked excel table loses borders on update Gary McGill Tables 2 March 27th 05 10:27 AM


All times are GMT +1. The time now is 03:39 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"