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

Problem with Excel link breaking



 
 
Thread Tools Display Modes
  #1  
Old March 12th 07, 03:56 PM posted to microsoft.public.word.docmanagement
Dee
external usenet poster
 
Posts: 98
Default Problem with Excel link breaking

Hi,

I need to send a file to various people using e-mail that contains Excel
data. To avoid having to send my Exel file with the Word file, I was advised
that the best way to do this was to Insert, Object, Excel object from file,
WITHOUT a link, display as icon. I then double-click to open the object,
copy, paste special WITH a link to varioius parts of my Word file to show
various parts of the embedded Excel file.

It works fine for awhile - I can double-click the Excel object icon, make
changes and they reflect in the Word file. However, as soon as I close the
Excel object worksheet, the link seems to disappear - no changes are made to
the Word file and if I try to update links, I get a message that the linked
object can not be found.

Help!
--
Thanks!

Dee
Ads
  #2  
Old April 2nd 07, 08:32 PM posted to microsoft.public.word.docmanagement
Robert M. Franz (RMF)
external usenet poster
 
Posts: 1,741
Default Problem with Excel link breaking

Hi dee

dee wrote:
I need to send a file to various people using e-mail that contains Excel
data. To avoid having to send my Exel file with the Word file, I was advised
that the best way to do this was to Insert, Object, Excel object from file,
WITHOUT a link, display as icon. I then double-click to open the object,
copy, paste special WITH a link to varioius parts of my Word file to show
various parts of the embedded Excel file.


What part from the excel file do you need to show in your file? A table
with cells can be copied over to Word directly, a chart likewise (as a
WMF/EMF picture, for instance). The Excel Object itself is rarely
needed, IMHO.


It works fine for awhile - I can double-click the Excel object icon, make
changes and they reflect in the Word file. However, as soon as I close the
Excel object worksheet, the link seems to disappear - no changes are made to
the Word file and if I try to update links, I get a message that the linked
object can not be found.


Well, you have (rightly) deselected the "link" option, so there are no
links to update. Word _should_ reflect what you have changed in the
object, so what's happening with your installation (OS and Office
version?) is not normal.

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word
  #3  
Old April 2nd 07, 08:44 PM posted to microsoft.public.word.docmanagement
Dee
external usenet poster
 
Posts: 98
Default Problem with Excel link breaking

Hi there,

Thanks for your response. I finally decided to approach it in another way -
I copied and pasted the Word file into the Excel file as an icon Word object.

This works, except that check boxes that are in the Excel file are very
faint when copied and linked into the Word file.

I need the entire Word object, BTW, because users may need bits and pieces
of it the Excel file to be transferred into the Word file and when changes
are made to the Excel file, all links should be updated.

Don't know if this makes sense!
--
Thanks!

Dee


"Robert M. Franz (RMF)" wrote:

Hi dee

dee wrote:
I need to send a file to various people using e-mail that contains Excel
data. To avoid having to send my Exel file with the Word file, I was advised
that the best way to do this was to Insert, Object, Excel object from file,
WITHOUT a link, display as icon. I then double-click to open the object,
copy, paste special WITH a link to varioius parts of my Word file to show
various parts of the embedded Excel file.


What part from the excel file do you need to show in your file? A table
with cells can be copied over to Word directly, a chart likewise (as a
WMF/EMF picture, for instance). The Excel Object itself is rarely
needed, IMHO.


It works fine for awhile - I can double-click the Excel object icon, make
changes and they reflect in the Word file. However, as soon as I close the
Excel object worksheet, the link seems to disappear - no changes are made to
the Word file and if I try to update links, I get a message that the linked
object can not be found.


Well, you have (rightly) deselected the "link" option, so there are no
links to update. Word _should_ reflect what you have changed in the
object, so what's happening with your installation (OS and Office
version?) is not normal.

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word

 




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
Link Excel to Word Mail Merge - found problem for mix data type Param Mailmerge 1 March 31st 06 12:29 PM
Non-breaking link between words Tily Microsoft Word Help 2 September 9th 05 09:43 AM
Problem of rows not breaking solved Jeff Layman Tables 0 April 12th 05 02:49 PM
Excel Paste Link - Insert row problem yoyoyooreo Microsoft Word Help 1 December 17th 04 05:15 PM
Link to Excel (Formatting Problem) bw Microsoft Word Help 2 December 13th 04 12:04 PM


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


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