Hi Jason,
I notice that you have posted the same question in this Excel Setup
newsgroup, which I have already responded. So please check my answer there
and if you need any further assistance on this particular issue, please
reply to me in that thread so I can follow up with you in time. Also,
please don't cross-post the same question so that our engineers can work on
your question efficiently. Your understanding and cooperation is
appreciated.
For your convenience, I have included my reply as follows:
************************
The files signed by trusted publishers will be trusted. It is same as that
the files are in the trusted location. Check if the certification is set
properly.
======================
1. Click Start, click Run, type certmgr.msc , and then click OK.
2. Expand Trusted Publishers, and then click Certificates.
3. Double-click a certificate, and then click the Certification Path tab.
Make sure that the information "This certificate is OK" is in the dialog
box.
4. Repeat step 3 for each certificate in this container.
If the issue persists, check the option below to see if it works.
=================
1. In Excel 2007, click Office Button Excel Options Trust Center tab
click on Trust Center Settings External Content tab.
2. Choose "Enable automatic update for all Workbook Links (not
recommended)". Click OK, OK.
What is the result?
************************
If anything is unclear or if you have any other concerns, please don't
hesitate to contact me.
Regards,
Emily Lin
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Date: Fri, 24 Aug 2007 14:07:22 -0500
| From: Jason
| Reply-To:
am
| User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
| MIME-Version: 1.0
| Subject: Data Connection Security in Excel 2007
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID:
| Newsgroups: microsoft.public.excel.setup
| NNTP-Posting-Host: fw01.tradingtechnologies.com 65.199.113.40
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.excel.setup:1452
| X-Tomcat-NG: microsoft.public.excel.setup
|
| I'm having an issue with a spreadsheet we've created in Excel 2007. The
| spreadsheet is configured to grab some data from a SQL server on our
| LAN. The problem is, you're hit with a security dialog that states
| "Security Warning: Data Connections have been disabled." When I add
| the location of the file to my Trusted Locations, the dialog goes away.
|
| Here's what we would like to do. We'd like to be able to sign the
| document with a certificate and set all of our client PCs to trust this
| certificate via GPO. The idea here is that any user can open a signed
| document from anywhere, whether it be off Sharepoint, a network share, a
| local copy, or whatever, and have the document automagically work
| without having to answer any dialog prompts. Idiot-proof active
| content, in other words. =)
|
| I've tried signing a test spreadsheet with a certificate and adding the
| same certificate to my Trusted Publishers container, but I'm still hit
| with a security warning when opening the file. Does anyone know of a
| way to take care of this?
|
| On a side note, I know you can resolve this by setting up Excel
| Services, but we don't want to have to worry about where our users are
| opening spreadsheets from. Any insight is appreciated. Thanks!
|