Finding links to other files

[AAMIFC]

Hi
I have an excel workbook were I have copied a worksheet from another file
into. I have removed all referances that I could find to other workbooks,
however I get the following message whenever I open the file.

The Workbook contains automatic links to information in another workbook.
Do you want to update the workbook iwth changes made to other workbook?

Have I missed a link some where? Is there a way I can locate all references
to other workbooks?

Thanks in advance.
Frank

 

[paul]

go to the edit menu and down near the bottom the links option should be NOT
greyed out,click on that and you choose the break links option......or use
find to find all references to other workbooks

 

[Max]

Try Bill Manville's excellent "FindLink" utility?
It's available at Stephen Bullen's page:
http://www.oaltd.co.uk/MVP/Default.htm

 

[JoeD]

Hello,
Having a similar problem in Excel 2002 (XP office, SP3). Using the FIND
function to search for cells with link fragment name, in Workbook and all of
comments/values/formulas. Fixed all it found, but link still appears with
update question. Where is it still hiding??

JoeD