You would be surprised where all links can hide. In addition to fromulas they
can be in named ranges. There is a great utility for finding them by Bill
Manville called FindLink...

http://www.oaltd.co.uk/MVP/
--
HTH...

Jim Thomlinson


"officegirl" wrote:

I took some sheets from someone else is workbook, the cells no longer link to
it ( they are hardcoded) yet it is keep asking me if I want to update how
can I stop that?