How do I find External Data Connections in a Workbook?

excel?

Board Regular
Joined
Sep 14, 2004
Messages
143
Office Version
  1. 365
Platform
  1. Windows
My Workbook displays a message banner along the top that says "Security Warning External Data Connections have been disabled" with an "Enable Content" button.

However, I should not have any links in this file. I have checked the Name Manager for any ranges to external files and it is completely empty. I have checked the Data ribbon and the Edit Links option is greyed out. I even have installed an add-in called Find Links to search for and list any links to external files and it says there are none.

Is there someplace else I need to look to find whatever connection is driving this message?

Thanks for any help you can provide.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
On the Data Tab, Click on Queries and Connections to see if there is anything there.
 
Upvote 0
On the Data Tab, Click on Queries and Connections to see if there is anything there.
Thanks - I'm not familiar with that option. However, it says 0 queries, so do not think it is my issue. Appreciate the suggestion.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top