how to find and unlink current worksheet from old worksheet

K

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.
 
K

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy to another worksheet 3
Macro to create validation list of worksheet names 1
Copy and Paste cells limitation 4
Print specific cells to another worksheet if check box cell links 0
Default format of cell comments 4
Hide Formula & Allow Copy 1
Links to Other Data Sources, Can't Turn off Application.DisplayAle 1
Macro to create a list 5

Top