• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

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