External References

  • Thread starter Thread starter Pinda
  • Start date Start date
P

Pinda

Is it possible to somehow locate all external references
without looking through each formula? I have created a
large spreadsheet with many formulae and I can't locate
the ex refs.

Thanks.

Pinda
 
In most cases, you should be able to find the names of all linked files under edit>links. What I do is note the file names there then go to edit>find >>options >>Within - Workbook to find the linked file name throughout the workbook. This is not 100%, for example it won't find links in VB, but in most cases it should lead you to all of them
 
Back
Top