Links and more links :(

  • Thread starter Thread starter Mike Mertes
  • Start date Start date
M

Mike Mertes

How can I find the ranges that containt links?

LinkSources and ChangeLink let you list and change the link sources but
neither of them will tell you WHERE the link formulas are.

You might think this is a silly question; Why don't I just use find? Well, I
did. It returned no results.

I tried several variations of spelling, and I tried searching for pieces of
the whole source name/path and still no luck. I do not have any hidden
ranges that would impede a find function.

This one really irks me.
 
You may have some linked named ranges. Try finding those and removing them.

Menu options Insert -> Name -> Define

Delete any named ranges that are pointing to other work books...

Hope this helps...
 
You must log in or register to reply here.

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

Ole Links (C++) 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
Change all Links 3
How change link source in long formula when source moved 4
Delete all Links via VBA 1
Finding worksheets with Broken Links to other workbooks 2
LinkSources full workbook path 1
DDE Links 2

Back
Top