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.
Issue
The Document Inspector can't remove these external links for you.
Recommended solution
-
Close the Document Inspector.
-
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.
-
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).
External links include external references that are used in:
-
Worksheet cells
-
Names
-
Objects, such as text boxes or shapes
-
Chart titles
-
Chart data series
No comments:
Post a Comment