Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 571
  • Last Modified:

Is there a way to permanently enable a data connection in an Excel workbook

I'm using Excel 2007 and creating a spreadsheet using ODBC to bring data in from a database.  Whenever I open that spreadsheet a box appears saying:
Security Warning: Data connections have been disabled  OPTIONS.  Under options you have two choices - Help protect me from unknown content and Enable this content.  I select Enable This Content, but I have to do this ever time I open the spreadsheet.  Is there any way that it will keep the choice I've selected?
0
nplanek
Asked:
nplanek
  • 2
1 Solution
 
sstampfCommented:
I think there is a setting which you can try (though I havent tried it myself):
1) Open Excel Options
2) Goto Trust Center
3) Click on "Trust Center Settings"
4) Goto "External Contents"
5) Under security setting for data connection choose "Enable all data connections"
6) Click "OK"
0
 
sstampfCommented:
If you dont know how to open excel options in 2007 see this:
http://spreadsheets.about.com/od/exceltips/qt/excel07_options.htm 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now