External links found

The Document Inspector found one or more links to data in other workbooks (external links) in your workbook. The names of the worksheets that contain the data you linked to are saved with your workbook but they aren't visible there.


The Document Inspector can't remove these external links for you.

Recommended solution

  1. Close the Document Inspector.

  2. Select the external links you want to remove and press Delete, or break the links if you want to remove the link but keep the calculated values.

  3. Run the Document Inspector again to verify the issue is resolved.

More about external links

The Document Inspector detects external links that appear in the Edit Links dialog box (in Excel, click Data > Edit Links).

Edit Links on the Data tab

External links include external references that are used in:

  • Worksheet cells

  • Names

  • Objects, such as text boxes or shapes

  • Chart titles

  • Chart data series

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!