When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Jenny wrote:

Hi,
I've copied and pasted two work sheets and merged them into a master
workbook in Excel, and have micro in the master workbook. Now each time when
I open the master workbook in Excel, it will have a message: "The workbook
you opened contains automatic links to information in another workbook. Do
you want to update the workbook with changes made to the other workbook?"...
Is there a way to get rid of this message? Any help will be greatly
appreciately.
Thanks,
Jenny

--

Dave Peterson