A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

formatting links from excel into word (extra line feeds)



 
 
Thread Tools Display Modes
  #1  
Old December 8th 04, 09:05 PM
JGT
external usenet poster
 
Posts: n/a
Default formatting links from excel into word (extra line feeds)

I am having the same problem - extra line feeds before and after the linked
data.

Note that my data is NOT pasted into a table, as Reply 1 presumes. It is
just a word or two, or a few characters and numbers, paste-linked from Excel
into paragraph text in Word. Thus the solution proposed in Reply 1 does not
work for my problem.

Also note that when I pasted the linked data I specifically chose the "Match
Destination Formatting and Link to Excel" button. The linked data most
definitely does not match the destination formatting. Word seems to randomly
choose some other formatting style to apply to the linked data.

I am using MS Word 2002 (10.4219.4219) SP-2 on a PC running Windows XP
Professional, 5.1.2600 Service Pack 1 Build 2600.

Thanks....John



"Cindy M -WordMVP-" wrote:

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

I am trying to use excel and word to make up a test. When I make a link from
excel to word, I get a line feed padded both before and after the result of
the link. I can delete those line feeds, but when any update of the links
takes place, the line feeds return. How do I make the line feeds not appear?

Unfortunately, you don't mention the version of Word involved, but I'm guessing
it's a more recent version. Word needs oen paragraph mark in order to store
information about the table it's maintaining in Word. I never see more than the
one paragraph mark, and if I select it then the entire table is selected.

If you're getting additional "line feeds" then perhaps you're including
something along with just the table cells in the selection in Excel...?

What you might try would be to activate text wrapping AROUND the table. Then you
should be able to select the paragraph mark linked to the table and format it
with a font size of 1 pt, making it virtually invisible. I just tested in Word
2003, and the formatting was retained even when updating the data.

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


Ads
  #2  
Old December 9th 04, 12:01 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default

Hi John,

If you go through Edit/Paste Special, choose "Unformatted text" and activate
"Link", do you get a better result?

I am having the same problem - extra line feeds before and after the linked
data.

Note that my data is NOT pasted into a table, as Reply 1 presumes. It is
just a word or two, or a few characters and numbers, paste-linked from Excel
into paragraph text in Word. Thus the solution proposed in Reply 1 does not
work for my problem.

Also note that when I pasted the linked data I specifically chose the "Match
Destination Formatting and Link to Excel" button. The linked data most
definitely does not match the destination formatting. Word seems to randomly
choose some other formatting style to apply to the linked data.

I am using MS Word 2002 (10.4219.4219) SP-2 on a PC running Windows XP
Professional, 5.1.2600 Service Pack 1 Build 2600.


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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing links to excel in form-protected word document Laura Microsoft Word Help 13 December 16th 04 01:57 AM
saving the workspace Mike Microsoft Word Help 3 December 9th 04 12:32 AM
How can I divide a page into three sections? Bonnie Microsoft Word Help 2 November 30th 04 06:21 PM
Word 無法重新建立一個DDE連結到microsft Excel 以完成目前作業 ord 無法重新建立一個DDE連結到microsft E Microsoft Word Help 0 November 26th 04 09:03 AM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 08:03 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.