Link to home
Create AccountLog in
Microsoft Excel

Microsoft Excel

--

Questions

--

Followers

Top Experts

Avatar of thedeal56
thedeal56

Broken Dynamic Links Between Excel and Word(Object Not Found)
I am using Office 2007, and I have a word file that has several dynamic excel links embedded in the document.  Both the excel and word files are stored on a local server.  The Word doc has lost the reference to the excel data, and will no longer reflect the changes made inside of the Excel Sheet.  When I right-click on any of the linked Excel info and click "Object", it says that the object is corrupt or no longer available.  When I try to edit the links to the files, I am able to do so, but it loses any prior worksheet/specific cell info attached to the link.  To help explain my problem, I'm attaching a picture of my link info.  What I am looking for is any one of these three things:

1.  I need a way to view the absolute path of where Word is trying to locate the file(This is underlined in RED in the picture)
2.  I need a way to redirect the link to the excel file, but still keep the specific worksheet/cell info contained in the original link. (The worksheet/cell info that I'm talking about is underlined in BLUE in the picture) Currently, when I update the link, this reference info is lost.
3.  I need some alternate way of re-linking my excel sheet to my word doc.  

I have read a little about this issue, and a few posts have suggested that Norton may be the cause of the broken links.  I have never had Norton installed, but I do use Trend Micro.  Is there a way to recover my dynamic links?  Any help on this will be greatly appreciated.  Thanks for reading.

*Edit*
I forgot to mention this:

If I try to open the Word file that's stored on the server,(The original, working file) It throws out an error(encountered a problem and needs to close).  The only way I was able to get into the doc in the first place was to save a copy of the file to my harddrive.  I thought I might should include that bit of info.  
excellinks.JPG

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of StellanRosengrenStellanRosengren🇸🇪

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of thedeal56thedeal56

ASKER

Thanks for the reply.  I tried to run your code in the vb editor, but I didn't get any results.  I think I do need some instruction on how to run it.  

SOLUTION
Avatar of dlc110161dlc110161🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.

SOLUTION
Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Microsoft Excel

Microsoft Excel

--

Questions

--

Followers

Top Experts

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.