Remove Linked File

[anupam]

When I open a particular excel file, it seems that file is searchin
for a linked file as it opens a "open dialog box". There are number o
charts in that file. Might be possible that one of them is linked t
another file, but now i want to remove the link. I don't want any fil
links. How can i make it possibl

 

[Max]

a. Try Bill Manville's excellent "FindLink" utility

It's available at Stephen Bullen's page:
http://www.bmsltd.ie/MVP/Default.htm

b. Try Jon Peltier's page for delinking chart data at:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

Scroll down and look for:

Sub DelinkChartFromData()
Sub DelinkChartFromLotsOfData()