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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

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