SOLVED

CONNECTIONS

%3CLINGO-SUB%20id%3D%22lingo-sub-1610415%22%20slang%3D%22en-US%22%3ECONNECTIONS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610415%22%20slang%3D%22en-US%22%3E%3CP%3EGOOD%20MORNING%2C%3C%2FP%3E%3CP%3EI%20AM%20NOT%20ABLE%20TO%20GET%20RID%20OF%20TWO%20OLD%20CONNECTIONS%20from%20my%20current%20file%20excel.%20THOSE%20COMMECTIONS%20CAME%20FROM%20TWO%20old%20EXCEL%20FILES%20I%20GOT%20READ%20OF.%20apparently%3C%2FP%3E%3CP%3EApparently%20connections%20cannot%20be%20interrupted%26nbsp%3Bif%20the%20origin%20files%20can't%20be%20retrieved.%20Any%20tip%3F%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3Egiovanni%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

GOOD MORNING,

I AM NOT ABLE TO GET RID OF TWO OLD CONNECTIONS from my current file excel. THOSE COMMECTIONS CAME FROM TWO old EXCEL FILES I GOT READ OF. apparently

Apparently connections cannot be interrupted if the origin files can't be retrieved. Any tip?

thank you

giovanni

4 Replies
Best Response confirmed by GIOVANNI1969 (New Contributor)
Solution

@GIOVANNI1969  You need to break the connection with the external reference.  There is 'existing connections' button under the DATA tab.  These external references can sometimes be hidden and hard to find.  They can be in graphs and charts, defined names, and other location.  If you can't find them I recommend this tool:

https://manville.org.uk/software/findlink.htm 

Hope this helps.

I had found it but it told me that connection couldn't be breached as the original file was removed (origin impossible to find)

sorted!!

many thanks

@mtarler 

sorted!

many thanks