| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Breaking the link
Jayceejay, Did you ever get your link broken? I have the same problem. And
I don't see where there was ever a clear answer to what to do. I do not want my "current" sheet linked to anything. I am with you.... HELP!! T "jayceejay" wrote: HELP..... I am working with Excel 2000. I have a workbook that contains a sheet that references cells in another workbook (ie: A link exists pulling the data from a source workbook to a destination workbook.) That SOURCE workbook has been deleted. HOW do I get the data in the destination file to "UNLINK" from the non-existent source? When I go to EDIT and LINK, I do not see a way to BREAK the link. I can do everything else BUT break the link. I just want the pesky boxes to stop popping up every time I open the file. Manually re-entering the data would be a real pain, because there is a lot of it. I know the solution is easy in XP, but I don't see the same "Break the Link" options in Excel 2000. Jay |
|
#2
|
|||
|
|||
|
Did you try that findlink addin that you quoted in your other post?
Bill Manville's FindLink addin: http://www.oaltd.co.uk/MVP/Default.htm T wrote: Jayceejay, Did you ever get your link broken? I have the same problem. And I don't see where there was ever a clear answer to what to do. I do not want my "current" sheet linked to anything. I am with you.... HELP!! T "jayceejay" wrote: HELP..... I am working with Excel 2000. I have a workbook that contains a sheet that references cells in another workbook (ie: A link exists pulling the data from a source workbook to a destination workbook.) That SOURCE workbook has been deleted. HOW do I get the data in the destination file to "UNLINK" from the non-existent source? When I go to EDIT and LINK, I do not see a way to BREAK the link. I can do everything else BUT break the link. I just want the pesky boxes to stop popping up every time I open the file. Manually re-entering the data would be a real pain, because there is a lot of it. I know the solution is easy in XP, but I don't see the same "Break the Link" options in Excel 2000. Jay -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing automatic link | Excel Discussion (Misc queries) | |||
| command for breaking link in excel is not seen. | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Linear Mode
