Trusted Data Connection

D

DFarrer

I'm connected to an in-house SQL 2005 server. Every time that I open my file
it warns me and declares that Data Connections have been disabled. The reason
is Excel doesn't know if my in-house SQL server is a "trusted source."

How do I declare to Office or Excel that my in-house SQL server is a
"trusted source?" Adding a SQL server name to the trusted source area is not
an option that I can see, it is generally worried about file locations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
Pivot Table Connection String - How to hide it? 4
Embedded Excel into Word with Tables 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Can't send emails on new PC 1
Allow Trusted Locations on my network - Group Policy (GP) 2
Want to have macro execute automatically when doc created 3
Opening XLS (2003) workbooks in 2007 (XLSX) 1

Top