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?