Breaking External Link

[nymyth]

howdy all,

I have a file that is showing an external link that I cannot break (Excel 2016), I have done the usual checks:
1. Check Conditional Formatting
2. Check Data Validations
3. Check Charts/Text boxes (don't have charts in this file)
4. Check Name Ranges
5. Check Compatibility Output

I finally saved the .xlsx as a .zip and found that the issue is hiding here: \xl\externalLinks\_rels. When I open this file I see this (where 'filename.xlsx' is the full path to where the file is):

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">

<Relationship TargetMode="External" Target="filename.xlsx" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath" Id="rId1"/>

</Relationships>

I have tried deleting this file, editing the file by removing the code, however every time I save the .zip back to .xlsx it all comes back in.

How can I find where this thing is hidden, or remove it entirely?

Cheers.

 

[robertocm]

Thanks!

After all the cleaning from the user interface, as you explain.

I finally delete the whole folder 'externalLinks'
located inside xl\ path
Then re-zip the files and change file extension (as usual) to get the excel file
Seems to be solved

Let me share a refence:
Find Invalid Links in Excel That Cannot Be Broken. Damir's Corner, Sept '16