Results 1 to 2 of 2
2004-09-18, 23:44 #1
- Join Date
- Sep 2004
- New York, New York, Zambia
- Thanked 0 Times in 0 Posts
Link in Word to Excel (Word & Excel 2002)
When I create link in a Word file to display up-to-date data from an Excel file (by copying the data in Excel, pasting it into Word and setting the Paste options to "Link to Excel"), a paragraph mark is also inserted. I can delete this but it comes back automatically. Is it possible to have the link sit in a line of text without a pilcro immediately following? If so, how. Many thanks.
2004-09-19, 09:22 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 406 Times in 335 Posts
Re: Link in Word to Excel (Word & Excel 2002)
I don't get this behaviour with Word 2000 - the linked object inserts into the document without an extraneous para mark, and this doesn't change with an update. Changing between 'spare' and 'in-line with text' doesn't seem to have any effect either.
Are you sure the extraneous para marker isn't in your Excel worksheet? For example, a cell that ends with a line feed - could be a cell with char(10), or an Alt-enter key combination at its end.
[MS MVP - Word]