Solved

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

Posted on 2010-09-14
2
523 Views
Last Modified: 2012-05-10
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
Comment
Question by:nplanek
  • 2
2 Comments
 
LVL 12

Accepted Solution

by:
sstampf earned 500 total points
ID: 33677582
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
 
LVL 12

Expert Comment

by:sstampf
ID: 33677640
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now