Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Office 2007 GPO

638 views
Skip to first unread message

jer

unread,
Feb 14, 2008, 9:13:57 AM2/14/08
to
I need to set the "Enable all Data Connections" and "Enable automatic
update for all Workbook Links" option in Trust Center->External Content
using
GPO but can't find the setting. I'm using the .ADM files.
Anyone found these settings?

JER

unread,
Feb 15, 2008, 5:19:40 AM2/15/08
to
I found which registry keys are edited when I change the 2 settings:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"DataConnectionWarnings"=dword:00000000
"WorkbookLinkWarnings"=dword:00000000


So I could run a reg-file during logon. It would be better to set this in
the same GPO as the rest of the Office-setting.
Anyone know how to make a ADM-file to set these settings?


"jer" <j...@rbk.cc> skrev i melding
news:F7E3AE21-9E76-4CC1...@microsoft.com...

Florian Frommherz [MVP]

unread,
Feb 15, 2008, 5:34:24 AM2/15/08
to
Howdie!

JER schrieb:


> [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
> "DataConnectionWarnings"=dword:00000000
> "WorkbookLinkWarnings"=dword:00000000

Untested:

CLASS USER

CATEGORY "Custom Excel settings"
POLICY "Enable all Data Connections"
KEYNAME "Software\Microsoft\Office\12.0\Excel\Security"
VALUENAME "DataConnectionWarnings"
END POLICY
END CATEGORY

and

CATEGORY "Custom Excel settings"
POLICY "Enable automatic update for all Workbook Links"
KEYNAME "Software\Microsoft\Office\12.0\Excel\Security"
VALUENAME "WorkbookLinkWarnings"
END POLICY
END CATEGORY

Remember right-clicking "Administrative Templates" -> View -> Filtering
to uncheck all "Only show.." boxes.

cheers,

Florian
--
Microsoft MVP - Windows Server - Group Policy.
eMail: prename [at] frickelsoft [dot] net.
blog: http://www.frickelsoft.net/blog.

JER

unread,
Feb 15, 2008, 5:55:09 AM2/15/08
to
Thank you very much!

"Florian Frommherz [MVP]" <flo...@PLEASELEAVETHISOUT.frickelsoft.net> skrev
i melding news:eyrdi57...@TK2MSFTNGP06.phx.gbl...

jef...@gmail.com

unread,
Mar 27, 2008, 12:34:05 PM3/27/08
to
On Feb 15, 6:55 am, "JER" <j...@rbk.cc> wrote:
> Thank you very much!
>
> "Florian Frommherz [MVP]" <flor...@PLEASELEAVETHISOUT.frickelsoft.net> skrev
> i meldingnews:eyrdi57...@TK2MSFTNGP06.phx.gbl...
> > blog:http://www.frickelsoft.net/blog.- Hide quoted text -
>
> - Show quoted text -

JER, did this work for you? I'm trying to do the same thing with my
group policy but it doesn't seem to be working for me.
P.S. I'm assuming you were doing this for Excel 2007, not 2003 right?

Florian Frommherz [MVP]

unread,
Mar 27, 2008, 2:31:01 PM3/27/08
to
Howdie!

jef...@gmail.com schrieb:


> JER, did this work for you? I'm trying to do the same thing with my
> group policy but it doesn't seem to be working for me.
> P.S. I'm assuming you were doing this for Excel 2007, not 2003 right?

What exactly were you trying? Did you try the ADM template that I posted
for JER?

cheers,

Florian
--
Microsoft MVP - Windows Server - Group Policy.
eMail: prename [at] frickelsoft [dot] net.
blog: http://www.frickelsoft.net/blog.

Use a newsreader! http://www.frickelsoft.net/news.html

0 new messages