It sounds like you had formulas referencing another sheet in your original
workbook. You can do a Find/Replace, using[*] as the find and leaving
replace with empty. You may need to do this in 1 sheet in the workbook.

--
Good Luck,
Peg


"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