Finding links to other files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top