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.
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.