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!