Hi Dave,
Thanks for your suggestions. By using Bill Manville's FindLink program, I
find a file link and solve the problem.
Thank you,
jenny

"Dave Peterson" wrote:

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