Finding and breaking links external source does not work

I have an XLSX workbook running on MS Excel 1908 that indicates having links to external sources after copying a sheet from another document.

When opening the document Excel provides the popup:

This workbook contains links to one or more external sources that could be unsafe Update / Don't Update

When I click Update: I get a window that states

We can't update some of the links in your workbook right now Continue / Edit Links...

When I select Edit links... I get the Edit links Window in which the reference is shown to the linked document.

I attempted the following:

'Break Link' does not work

'Change source' does not work

A search in Excel for the string of the location (in cells, entire workbook) does not yield a result.

No Names are defined with this reference.

No custom VBA scripts exist with this reference.

Where more can this link be located? And how to remove it?

2 Answers

Maybe use Find and look for a [

(Example below) IF there is an external link it should inform you.

I hope this helps.

1

My bet would have been on a defined name. Assuming you checked all these places:

Failing that, you can try

1. File > Info > Inspect Document, or
2. File > Info > Edit links to files, or
3. Try saving the document back into an older .xls format then resaving in .xlsx, or
4. Try to unhide any hidden names in VBA like so (source ). Also have a search for "VBA hidden external connections or links"

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy