Links
 

at my company I have several different networks. I'm trying to link values
from a cell in one network to a spreadsheet in another network. It linked
fine however once I close the spreadsheet that I just set up the links on and
try to open it again I click on yes when it asks me to update my links. then
it says "file not found" and gives me a box to browse for it. When I browse
and select the worksheet that my links are coming from it says "Cannot find
Macro1". I didn't create any Macro's so I don't know why it is looking for
Macros. Because of this my links don't update themselves. Can someone explain
why this is happening.
Thanks in advance. If i'm not clear enough just write back and I can try to
explain better. Thanks. Travis

Correction. The links are not in separate Networks. They are in the same
folder in the same network. Just separate files. Please help.

"Dahlman" wrote:

at my company I have several different networks. I'm trying to link values
from a cell in one network to a spreadsheet in another network. It linked
fine however once I close the spreadsheet that I just set up the links on and
try to open it again I click on yes when it asks me to update my links. then
it says "file not found" and gives me a box to browse for it. When I browse
and select the worksheet that my links are coming from it says "Cannot find
Macro1". I didn't create any Macro's so I don't know why it is looking for
Macros. Because of this my links don't update themselves. Can someone explain
why this is happening.
Thanks in advance. If i'm not clear enough just write back and I can try to
explain better. Thanks. Travis

The first thing I'd do is look for links between workbooks.

Bill Manville's FindLink addin may help you find the hard to find links:
http://www.oaltd.co.uk/MVP/Default.htm

Maybe you added a shape/object and assigned a macro (in error) that's causing
the trouble.

Dahlman wrote:

at my company I have several different networks. I'm trying to link values
from a cell in one network to a spreadsheet in another network. It linked
fine however once I close the spreadsheet that I just set up the links on and
try to open it again I click on yes when it asks me to update my links. then
it says "file not found" and gives me a box to browse for it. When I browse
and select the worksheet that my links are coming from it says "Cannot find
Macro1". I didn't create any Macro's so I don't know why it is looking for
Macros. Because of this my links don't update themselves. Can someone explain
why this is happening.
Thanks in advance. If i'm not clear enough just write back and I can try to
explain better. Thanks. Travis

--

Dave Peterson