I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Bob wrote:

I copied and pasted several worksheets from one workbook to another. When I
open the new workbook I keep getting a message to update or not. How do I get
rid of any links to the other workbook.
I have checked all formulas and none have a link to the other book. I also
selected tools/option/edit and unticked the update box, but I still a message
to 'continue'.
How do I sort this out?

--
Bob

--

Dave Peterson