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

Posted on 2008-11-13
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:Degenerateuk
    LVL 82

    Accepted Solution

    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

    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

    Thankyou very much for the swift help.

    Author Comment

    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.


    CATEGORY "Custom"
          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
                END ACTIONLISTON
                      KEYNAME "Software\Classes\Excel.Sheet.8"
                            VALUENAME "BrowserFlags"
                            VALUE NUMERIC 0
                END ACTIONLISTOFF
          END POLICY

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
    This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now