Report External Links

Generates a report of all the external links in a Workbook and produces a report on a new Worksheet in the current Workbook.

Example: Here is a Worksheet with some cells with calculations:

After running the report, the following tab is created with the results:

The report provides the following for each external links:

  • Type - The type of external link, for example Cell, Shape, Named Range.
  • Name - In the case of a named range, this will indicate the range name.
  • Location - The location of the link, in the case of cell links, a hyperlink to the cell is provided.
  • Offender - The type being linked to.
  • Value - The value of the cell with the link.

Created with the Personal Edition of HelpNDoc: Easily create Help documents