how do you find external links in a multi-workbook file?

berbes

New Member
Joined
Dec 9, 2004
Messages
31
how do you find external links in a multi-workbook file? there's got to be an easier way than cell by cell, worksheet by worksheet, right??

my blisters thank you!
jackie
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
I know you can use DominicB's add in for this (Download from his webpage)

However, it only shows that there are links, not where they are
 

berbes

New Member
Joined
Dec 9, 2004
Messages
31

ADVERTISEMENT

i can't find where to look for 'cells>' to find and remove links. thanks for taking this extra time for me, mark (or anyone!!!).
 

berbes

New Member
Joined
Dec 9, 2004
Messages
31
i can't find where to look for 'cells>' to find and remove links. thanks for taking this extra time for me, mark (or anyone!!!). i installed the add-in just fine, but still stuck.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,721
Members
410,630
Latest member
JFORTH97
Top