How do I fix this custom ADM so that it will work, or apply this setting through another method.

Posted on 2008-11-13
Medium Priority
Last Modified: 2012-06-22
I am attempting to set a registry value through group policy, so that when an excel file is opened through a browser it will definitely spawn in a new window.

So far I have identified the registry key.

Windows Registry Editor Version 5.00

@="Microsoft Excel Worksheet"

Im not sure if the @ part is needed, but as a .reg this will work.

Then I have attempted to make a .adm file to use group policy to apply this setting.  I am aware that I cannot set HKEY_CLASSES_ROOT values with a .adm, so I am applying it to HKEY_LOCAL_MACHINE\Software\Classes\Excel.Sheet.8

The .adm I have so far is below, however I am new to the syntax and whilst this parses correctly when loaded into the GP editor, it doesnt give any settings.  What changes should I make to get this to work?


      POLICY "Excel Open File Settings Fix"
      KEYNAME "Software\Classes\Excel.Sheet.8"
            PART "Open In Same Browser Window"
            VALUENAME "BrowserFlags"
            DEFAULT "00000008"
            END PART

Cheers for any help
Question by:Adam Beardmore
  • 3
LVL 85

Accepted Solution

oBdA earned 1000 total points
ID: 22948794
You need to go to the View > Filter menu in the GP editor and uncheck "Only show policies that can be fully managed"; you will then see the policy you created in red instead of the standard blue.
Note that this is not a real policy, it's a "preferred setting" or "tattooing" of the registry. This change will *not* "go away" or be reset to a former/default value if you remove the policy, it will stay on the last value applied as if you changed the registry manually. And should you ever decide to remove the adm file from the GPO, edit the GPO first and set this back to "Not configured"; only then remove the adm file. If you remove the adm file while the setting is stil active, it will still be in the GPO, but you won't be able to change it anymore.

Author Comment

by:Adam Beardmore
ID: 22948878
Fantastic thanks for your help!

I realised that it is the same as a manual registry edit, we are sure that this is a setting we would like permanently.

I'm really surprised that my syntax was correct, I was almost certain I had the statements in the wrong order or something...



Author Closing Comment

by:Adam Beardmore
ID: 31516320
Thankyou very much for the swift help.

Author Comment

by:Adam Beardmore
ID: 22949361
Further to all of the above.  While the solution helped me apply the .adm, I found it didn't function as expected.  I did a bit more research into syntax and have made this one instead, in case somebody wants to use the code.  This has been tested to work on Windows 2k SP4 and XP Pro SP3 workstations.


      KEYNAME "Software\Classes\Excel.Sheet.8"      
      POLICY "Set Excel Open New File Preferences."
      EXPLAIN "Enabled will force the opening of excel files in new windows (no embedded spawn from IE).  Disabled will enable the embedding."
                  KEYNAME "Software\Classes\Excel.Sheet.8"
                        VALUENAME "BrowserFlags"
                        VALUE NUMERIC 8
                  KEYNAME "Software\Classes\Excel.Sheet.8"
                        VALUENAME "BrowserFlags"
                        VALUE NUMERIC 0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

839 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