<div>
If you dont know how to open excel options in 2007 see this:<br />
<a href="http://spreadsheets.about.com/od/exceltips/qt/excel07_options.htm" rel="ugc">http://spreadsheets.about.com/od/exceltips/qt/excel07_options.htm</a>&nbsp;<br />

</div>


If you dont know how to open excel options in 2007 see this:
http://spreadsheets.about.com/od/exceltips/qt/excel07_options.htm [http://spreadsheets.about.com/od/exceltips/qt/excel07_options.htm] 


<div>
<div class="content wysiwyg-content">
I'm using Excel 2007 and creating a spreadsheet using ODBC to bring data in from a database. &nbsp;Whenever I open that spreadsheet a box appears saying:<br />
Security Warning: Data connections have been disabled &nbsp;OPTIONS. &nbsp;Under options you have two choices - Help protect me from unknown content and Enable this content. &nbsp;I select Enable This Content, but I have to do this ever time I open the spreadsheet. &nbsp;Is there any way that it will keep the choice I've selected?
</div>
</div>


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?

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

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.