• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data connections have been disabled

Christina Calkins

Christina Calkins

Member
I am a basic Excel user trying to learn more. I have a spreadsheet that is password protected and each time I open it up it has "Security Warning" Data connections have been disabled. When I click on the Options button the Security Alert comes up to enable the content. I click to enable however, it never saves and I have to redo the process eveytime. How do I get it to enable all of the time?
 
Hi, Christina Calkins!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, where's the location of the file you're trying to open? Is it downloaded in any folder, either local or networked, or is it an email attachment or a link from a web page? If it isn't "downloaded" try to do it no matter where, open it (you should be prompted as previously), save it, re-open it (and you shouldn't be prompted again).

Regards!
 
Thank you for the (must read) info. I have will make sure to read. The file is on our companys I-Drive under a folder that I created. It has multiple tabs within the file (8+). It is saved as a Microsoft Office Excel Worksheet. 3,051 KB. Everytime I save it, I still get prompted again to diable. I can always leave it alone, it is just annoying.
 
Hi, Christina Calkins!

A few questions:
It's a .xlsx or a .xlsm file?
Does it has macros?
If yes, any that runs at open time or before saving or closing?
Does it let you save it?
If you do, the modification date matches with your access?

When opened:
Go to Data tab, Connections group, Connections icon, and,
- are there any entries?
- select each one and click on Properties and write down the details.

But before:
Go to File tab, Options, Advances, and in the section "When calculating this workbook", check that,
- Update Links to other Documents, enabled
- Save External Link Values, enabled

Otherwise, consider uploading a sample file, removing the password or changing it to something trivial and if necessary replace sensitive data with dummy or anonymized values. Or at least the macro code that it has, in all modules and class modules (ThisWorkbook and each worksheet), and userforms if suitable.

Regards!

PS: Just in case I assumed something wrongly, check this:
Go to File tab, Options, Trusted Center, Trusted Center Configuration, External Content/Data, and confirm that:
- External Content/Data Security Configuration is set to Enable All (not recommended) or Ask The User
- Workbook Links Security Configuration is set to Enable All (not recommended) or Ask The User
 
Last edited:
I went to the Connections and there was one connection that existed. There wasn't any details to write down however, I noticed that the connection that was there was not needed. So I deleted it, enabled and saved. When I open it up now it is not there. Thank you so much for your help. I am looking forward to learning more. Like I said, I am just a basic user wanting to become more.

Best Regards,
Christina
 
Hi, Christina Calkins!
Then it was that, an old connection not used anymore.
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!
 
You must log in or register to reply here.
Back
Top