This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I received an excel file containing vba code from someone. After opening the file, I get the following Security Warning:
"Data connections have been disabled".
Then there is a button to "Enable Content".
If I don't click the "Enable Content" button and I try to import a new data set by right-clicking and choosing "Refresh", I then get the following warning:
"You are connecting to an external data source. Do you want to continue? Connections to external data sources can be used to access confidential information, or to cause harm to your computer. If you do not fully trust the source of this file, click Cancel."
Can someone let me know what this external data source is?
When I looked in the VBA editor I see the information in the screenshot below. As you can see it contains a password. Can anyone let me know what this means? Am I actually connecting to an external database by using this VBA?
Really appreciate any help.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Glad to know that this solved your problem. Request you to mark it as answered so that the question no longer remains open and others can also benefit from the answer.
Ok great - thanks so much for your help. I really appreciate it.
Sorry - why do I get the "Data connections have been disabled" warning when I open the file and can this be permanently removed?
VBA code is not making a connection.
If you go to data tab > Click on Queries and Connection > You will be displayed with the connection which you can double click and open > if you go under Definition tab, you will find the location of Connection File.
If you go into Used In tab, you will see that it populates A1:AQ100 range.
To Run this Query, you need to press Refresh All in Data tab. (But the definition file should be available on your computer)
Thanks for the reply,
Are you able to take a look at the file at the following link:
https://drive.google.com/file/d/1V8UXKGc3o4FQZBXn481say1riVslfB8l/view?usp=sharing
This requires the study of your VBA code to pinpoint the exact answer. Could you please upload a sample workbook sans confidential data to Onedrive / Googledrive / Box / Dropbox or any other file host and share the link? It will help us to give prompt and high quality solution.