how to find and unlink current worksheet from old worksheet

[kmjmail]

I have a worksheet I have used for years. Every time I open it up “This
workbook contains links to other data sources†pop up. I always choose Don’t
update. I would like to know how to find those links and remove them so it
dose not keep asking me. I don’t want it to update the links.

Thank you so much for your help.

 

[Dave Peterson]

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

 

[kmjmail]

Thank you for your response but I am not sure if I can download anything to
my work computer.

Do you know of any other way?

Thank you.

 

[Dave Peterson]

You may be able to find links in the worksheet (in formulas) by searching for [
or ]. Those will be part of the formula that points at the other workbook.

But formulas aren't the only place where links can hide. They can be in names,
charts, ..., lots of places.

Bill Manville's program checks more locations than I can think of!

I'd try to get special approval for this utility.