T
TheDeal56
I have tried posting this question on another site, but I haven't had any
replies yet. If I need to provide more info, please let me know. Here's my
question:
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. 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.
I reference a pic in my post, but I didn't see a place to attach it. Here's
a link to my other post that has the pic attached.
http://www.experts-exchange.com/Sof.../Office_Suites/MS_Office/Word/Q_24292453.html
Let me know if you can't see the pic, and I'll upload it somewhere.
replies yet. If I need to provide more info, please let me know. Here's my
question:
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. 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.
I reference a pic in my post, but I didn't see a place to attach it. Here's
a link to my other post that has the pic attached.
http://www.experts-exchange.com/Sof.../Office_Suites/MS_Office/Word/Q_24292453.html
Let me know if you can't see the pic, and I'll upload it somewhere.