Breaking Link To Another Workbook

[John Gregory]

I radically modified an Excel 2000 workbook that was linked to another
workbook; Book 2. I'll soon have the entire book completely converted to
other sources of data. I'm concerned that when I break the last dependency
on that original source, something in the modified book will continue to ask
me to link it to Book 2. Can someone please comment? Will the modified
workbook automatically stop the popup window asking to assign that link or
will I have to take some special steps?

 

[Tushar Mehta]

XL won't try and update the link if you really don't have any link.
You might want to check out Bill Manville's FindLink utility at
http://www.bmsltd.ie/MVP/MVPPage.asp#BillManville

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions