Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyper Links | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Links to other files | Excel Discussion (Misc queries) | |||
HELP!!! Missing Links!!! | New Users to Excel | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |