To break unwanted or orphaned links between workbooks in Excel 2002 & Excel 2003:
1. From the Edit menu, select Links.
2. In the Edit Links dialog box, select the Source workbook and click Break Link.
Screenshot // Breaking Links Between Workbooks
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"For earlier version this reference is good:
http://personal-computer-tutor.com/abc2/v17/chad17.htm
However, I only finally got rid of my phantom link by pointing the link reference back at the current file. At which point the link disappeared!"
"How do you break a link between Word and Excel via VBA. I am using Word and Excel 97.
Thanks,
Philippe"
How to break links on excel 2000
"How do you break a link between Word and Excel via VBA. I am using Word and Excel 97.
Thanks,
Philippe"
Excel 2000 and prior won't even tell you what cells the links are in as far as I know!
How do you break links in older versions of Excel?
"For earlier version this reference is good:
http://personal-computer-tutor.com/abc2/v17/chad17.htm
However, I only finally got rid of my phantom link by pointing the link reference back at the current file. At which point the link disappeared!"
"How do you break a link between Word and Excel via VBA. I am using Word and Excel 97.
Thanks,
Philippe"
How to break links on excel 2000
Excel 2000 and prior won't even tell you what cells the links are in as far as I know!
How do you break links in older versions of Excel?