Excel to Word OLE linking problems

MS EXCEL

    Sponsored Links

    Next

  • 1. I get the error msg "the system cannot find the file specified"
    I'm using Excel 2003 and get the message "the system cannot find the file specified" when I try to open an attachment from Excel. Is there a missing component?
  • 2. Autorecover in excel does not work
    A user suggested that they could not autorecover a file in excel. I set the autoreover to 1 min in excel and opened the specified autorecover folder to see whether it added a file while open...it didn't. I tried in word and this worked fine. Anyone have any suggestions.
  • 3. =IF(D57=2,H4,IF(D57=3,H5,IF(D57=4,H6,IF(D57=5,H7,IF(D57=6,H8,IF(D
    I want to put =IF(D57=2,H4 to D57=17,H19 arguments in this function.while we can put only upto 6 or 7 arguments in this formula. Pease help how can I put as much arguments in same formula or funtion as much I want. Thanks, Riaz Malik
  • 4. 'Cannot shift objects off sheet' error message (group/outline)
    When I try to hide or group columns in an Excel file, I get the warning message: 'Cannot shift objects off sheet'. Why does this happen? How do I remove this blocking factor? Thank you, Peter
  • 5. Import External Data...Import Data... Error
    I am using Excel and Access 2003. I set up a querytable to get data from an Access database query, using the menu data...Import External Data...Import Data... It was easy to set up and worked perfectly for a few days. Then all of a sudden I received the following message and can no longer refresh the query. I tried to set up the file again and I still get the same error message. Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. I have confirmed that the query run successfully in Access. The query runs against an ODBC linked table and Excel asks for the user id and password to the oracle table so I know that part is working. As a precaution, I have also confirmed that no one (including me) is in the database. Note - there are 334 records in the query result so that is not an issue either. Any ideas? Rebecca

Excel to Word OLE linking problems

Postby GarrettWagner » Wed, 19 Sep 2007 23:32:22 GMT

I linked Excel data to Word using Paste Special command. I copied the
data
from Excel and pasted the data into Word using Paste Special,
choosing
Microsoft Excel as the object and clicking Paste Link.

Unfortunately, the data is not visible in Word. Actually, it's
displays only
as a box. I can access Excel by double clicking the box and opening
Excel
through Word. However, I can not see the Excel data as an object.


I updated Office 2003 from the Microsoft website. I updated Windows
XP
through Windows Update and I ran searches through Microsoft database
and
could not find a solution to this issue. I could not find anything on
OLE
patches, OLE problems. I couldn't find anything.


Re: Excel to Word OLE linking problems

Postby garfield-n-odie [MVP] » Thu, 20 Sep 2007 04:41:43 GMT

In Word, click on Tools | Options | View tab | uncheck the "Picture 
placeholders box and check the "Drawings" box | Print tab | check the 
"Drawing objects" box | OK.





Similar Threads:

1.Word 2007 Linked OLE Object to Excel 2007 file performance problem

Hello gang,

I have a 34 page Word document that includes 18 Linked OLE objects to 
various columns from a Excel 2007 file with 18 worksheets.  If I put both the 
word file and excel file on my local machine and launch the word file, it 
opens in about 12 seconds, which is acceptable.  If I move the two files to 
any file server on our network (I tried multiple servers) and fix the links 
to point to the UNC path of the Excel file, the word document will take over 
10 minutes to open, which isn't acceptable.  

So my question be why is performance so bad from UNC paths?  I know it's not 
our file servers because no other files have this kind of problem opening, 
etc.  

I've also tried this on various operating systems (Windows XP, Vista, and 
Windows Server 2003 via Citrix), all with the same results.

Thanks,
Aaron LaBeau
Software Analyst/DBA
Schenck Business Solutions

2.Linking (OLE) with Excel and Word

I linked Excel data to Word using Paste Special command. I copied the data 
from Excel and pasted the data into Word using Paste Special, choosing 
Microsoft Excel as the object and clicking Paste Link.

Unfortunately, the data is not visible in Word. Actually, it's displays only 
as a box. I can access Excel by double clicking the box and opening Excel 
through Word. However, I can not see the Excel data as an object.

I updated Office 2003 from the Microsoft website. I updated Windows XP 
through Windows Update and I ran searches through Microsoft database and 
could not find a solution to this issue. I could not find anything on OLE 
patches, OLE problems. I couldn't find anything.

Does anybody know how to fix this? HELP!!!

3.OLE: linking Word-text in Excel-cells

Hi,
I like to know if and how it is possible to link more than 1 paragraph of 
Word-text at once in an Excel cell? When I copy-Paste Special etc the 
paragraphs all appear in their own Excel cell. So, e.g.: 3 paragraphs apeear 
in 3 cells instead of in 1 cell
Kindly Regards.
Karel

4.OLE link between word and excel dies

I have posted on this in the Word.applications group several times
over several years with no resolution.  I am wondering if the MVPs
lurking in the Excel forums have any suggestions for me.

Here's my most recent experience:

Has anyone heard of a fix for the long standing bug where an OLE link
between Word and Excel dies - sometimes permanently, sometimes only
for a minute or two?

I just had a particularly nasty recurrence that probably requires
rebuilding the spreadsheet again as the Excel link in Word is dead and
replaced by a picture of what the displayed area was when the link
died. When the link dies, you get an error message that Excel has had
a problem and must close.  Unfortunately, once the link dies, if you
select the object and it comes up as a picture, you cannot recover the
link again.  If you just ignore the warning, do nothing and wait a
while, the link often re-connects.  I tried to continue, but as
always, The hurrieder I go the behinder I get.

I am actually using Word, and just filling in the blanks in a
spreadsheet window created in word by selecting Insert > Excel
Spreadsheet      and then typing within the spreadsheet window.  I
don't even know where the spreadsheet resides so I can try to recover
it.

This has been a problem since at least Office XP and is no better in
2007.  I have had MS work on this for me in both versions many times
over the years and it remains unresolved.  All files are local, and on
the same drive/partition.  ( on each of the several systems I have had
this problem with )   Memory load, other running programs, and default
printer have no effect on the liklihood of a recurrence.  All systems
with this problem are XP - fully patched at the time.

any thoughts?

5.OLE links breaking between Word and Excel

We are using Prosystem FX Engagement and we frequently have links between 
Word and Excel that are just basic OLE links (Office 2003).  A table will be 
copied from Excel and pasted into Word using Edit - Paste Link.  Now 
Engagement folder structure is setup as follows:

C:\Pfx Engagement\wm\workpapers\{User Profile GUID}\{Binder GUID}\{Workpaper 
Files}

A path from my personal machine is: 

C:\Pfx 
Engagement\WM\Workpapers\{9ADF29EC-869B-4A60-A754-E952C09CA4CB}\{6A8ED35B-D8E9-410B-9B6D-0FC58E9199E4}\ {00A14CA8-294F-4CE5-958A-52EDCD638C10}.doc

 
A key piece of this is the User Profile GUID.  Every user has a unique GUID 
so the same document in the same binder (folder) on another person machine 
will have a different path because the Profile GUID is different.

Now when a set of linked files are working normally they seem to just look 
to find the linked file within the same folder that the file resides in and 
ignores the full path.

In a situation where the link is broken it appears to change the type of 
link to use the full path.  So on one person machine the linking works fine 
but on everyone else machines they do not because the path to the same file 
is actually different.

 
The steps that lead to the error are:

1)     A user creates links from an Excel file into a Word file.  At this 
point the links will work for everyone.

2)     A change to the file is requested and someone edits the excel file.  
Word file looks normal for this user

3)     Another user obtains copies of the files and the Word doc will show 
"Error! Not a valid link." for each of the affected links  

If you go into Edit Links you can see that the link type is different.  I 
can recall what each type says.

 

This is a sporadic issue throughout multiple offices.  Some offices like 
mine office have had to deal with it for years while others have never seen 
it at all.

We have a word processor in the office that has been with us for years that 
does the same steps and she has gone months where everything is fine and then 
it will pop back up again.

One of our word processors talked with her counterpart in an office that 
hasn had the problem and compared their process steps to try and find a 
cause with no avail.

I have tried to replicate the break with no luck as well.

If anyone has any suggestions I would appreciate the help.

Thanks,

-- 
Travis

6. OLE links to Word bookmarks are problematic in Excel

7. problem with linking to a word document using an OLE object

8. Excel OLE linking



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 89 guest