How do I get rid of a phantom external data connection warning

%3CLINGO-SUB%20id%3D%22lingo-sub-2997350%22%20slang%3D%22en-US%22%3EHow%20do%20I%20get%20rid%20of%20a%20phantom%20external%20data%20connection%20warning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2997350%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20on%20a%20Macbook%20Pro%20using%20Microsoft%20Excel%20for%20Mac%20Version%2016.55.%20Every%20time%20I%20open%20my%20file%20I%20get%20a%20Security%20Warning%20-%20External%20Data%20Connections%20have%20been%20disabled...%20but%20there%20are%20no%20External%20Data%20Connections%20in%20the%20workbook%2C%20anywhere.%26nbsp%3B%20How%20do%20I%20get%20it%20to%20stop%20giving%20me%20this%20warning%20with%20link%20to%20enable%20content%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2997350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am on a Macbook Pro using Microsoft Excel for Mac Version 16.55. Every time I open my file I get a Security Warning - External Data Connections have been disabled... but there are no External Data Connections in the workbook, anywhere.  How do I get it to stop giving me this warning with link to enable content?

4 Replies

@mscottmiller I suspect that the file has been authored in Excel for Windows and includes elements that aren't supported by Excel for Mac, like Power Query. Look on the Data Ribbon, Connections. Do you see something like this?

Screenshot 2021-11-23 at 17.08.03.png

@Riny_van_Eekelen No nothing is listed in that data connections pop-up and I am the one who created the workbook 100% in Excel for Mac. I have no idea where this came from.  I did copy over a couple of tabs from another workbook that I created in Excel for Mac but when I pasted I pasted only the values and rewrote the formulas; even redid the pivot table from scratch.

 

Screen Shot 2021-11-23 at 11.15.24 AM.png