Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unlinking between workbooks
I have a problem with documents that I have created, then copied to be used on another computer and then put back into my computer. When I make a copy, it ends up linking that to another file...half the time it is one that was on a floppy disk. I don't want this link between worksheets, but it prompts me every time I open the file if I want to update info. I always say no. Is there any way to remove this link, and, in the future, prevent this from happening? If I go into the "links" under edit, it does not give me an option to remove this link, only update or change it. How can I make this link go away? Thanks for your help. -- svarnell64 ------------------------------------------------------------------------ svarnell64's Profile: http://www.excelforum.com/member.php...o&userid=26638 View this thread: http://www.excelforum.com/showthread...hreadid=399143 |
#2
|
|||
|
|||
If you can find the location of the link, delete or modify the contents of
the cell(s). Use the Find function to locate the = sign with which all links must begin. "svarnell64" wrote in message ... I have a problem with documents that I have created, then copied to be used on another computer and then put back into my computer. When I make a copy, it ends up linking that to another file...half the time it is one that was on a floppy disk. I don't want this link between worksheets, but it prompts me every time I open the file if I want to update info. I always say no. Is there any way to remove this link, and, in the future, prevent this from happening? If I go into the "links" under edit, it does not give me an option to remove this link, only update or change it. How can I make this link go away? Thanks for your help. -- svarnell64 ------------------------------------------------------------------------ svarnell64's Profile: http://www.excelforum.com/member.php...o&userid=26638 View this thread: http://www.excelforum.com/showthread...hreadid=399143 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions | |||
Tools/Compare and Merge Workbooks - Excel 2003 Pro | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |