Excel "External Data Connections have been disabled."

%3CLINGO-SUB%20id%3D%22lingo-sub-1602851%22%20slang%3D%22en-US%22%3EExcel%20%22External%20Data%20Connections%20have%20been%20disabled.%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1602851%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wish%20to%20find%20and%20eliminate%20%22external%20data%20connections%22.%3C%2FP%3E%3CP%3EI%20am%20familiar%20with%20creating%2C%20modifying%20and%20deleting%20external%20links%20to%20another%20Excel%20workbook.%3C%2FP%3E%3CP%3EHowever%2C%20I%20am%20unfamiliar%20with%20%22External%20Data%20Links%22%3B%20I%20think%20I%20created%20them%20when%20I%20used%20File%26gt%3BImport%26gt%3BCSV%20File.%3C%2FP%3E%3CP%3EI%20don't%20need%20to%20import%20the%20files%2C%20especially%20if%20they%20create%20an%20unnecessary%20link.%20I%20can%20easily%20cut%20and%20paste%20special%20the%20values%20into%20my%20workbook.%3C%2FP%3E%3CP%3EHow%20do%20I%20find%20and%20remove%20these%20unnecessary%2Funwanted%20%22external%20data%20connections%22%3F%3C%2FP%3E%3CP%3EI%20am%20using%20Excell%20for%20Mac%2016.40.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1602851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

I wish to find and eliminate "external data connections".

I am familiar with creating, modifying and deleting external links to another Excel workbook.

However, I am unfamiliar with "External Data Links"; I think I created them when I used File>Import>CSV File.

I don't need to import the files, especially if they create an unnecessary link. I can easily cut and paste special the values into my workbook.

How do I find and remove these unnecessary/unwanted "external data connections"?

I am using Excell for Mac 16.40.

0 Replies