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
--
paul
remove nospam for email addy!



"AAMIFC" wrote:

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

Try Bill Manville's excellent "FindLink" utility?
It's available at Stephen Bullen's page:
http://www.oaltd.co.uk/MVP/Default.htm
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AAMIFC" wrote in message
...
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

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


"AAMIFC" wrote:

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