[THIN] Tip: Fixing quick access toolbar in Office 2007 to save when using roaming profiles

  • From: Jim Kenzig <jkenzig@xxxxxxxxx>
  • To: THIN <thin@xxxxxxxxxxxxx>
  • Date: Fri, 23 Apr 2010 09:18:42 -0400

 Hi All,
I went back and tackled this issue again.  There are many sites out there
that suggest the fix of this issue.

First some background.  When Microsoft Office 2007 was released Microsoft
placed the settings for the Quick Access toolbar (qat) in the Locallow
folder of the users profile.  The locallow folder can never roam so if sites
were using roaming profiles, a users settings on they set on their Office
Applications quick access tool bar would get lost after every logout of
their session.  This became quite a frustration for users.

Over the years many suggestions were given including using scripts to copy
the qat files in and out of the users profile at login and logoff.  A big
pain and a way to slow down logins. Microsoft released a "fix" to add a
registry key to the users profile (http://support.microsoft.com/kb/958062 and
later included in Office 2007 Service Pack 2) that was a Manual fix.  Admins
had to edit each users registry in order for this to work.

Enterprising people came up with solutions to use Citrix Profiles in order
to change the setting (
http://blogs.sepago.de/helge/2009/12/09/fixing-office-2007s-quick-access-toolbars-with-citrix-user-profile-manager/
)

Ok but I don't use Citrix profiles and I have a thousand users with roaming
profiles that have the issue.
SO still searching I ran across an obscure blog posting by Kay Sellenrode
that links to an Adm file that provides the ideal solution.  Set the Key for
the qat file redirection in the Microsoft fix via Group Policy.
Kays post is here
http://geekswithblogs.net/ksellenrode/archive/2009/01/05/128362.aspx Bravo.
So I guess the solution has been around a bit it just takes some searching
to find it.
Here is Kay Sellenrodes Posting:

"A lot of people that migrated to Office 2007 probably ran into the issue
that the QAT (Quick Access Toolbar) is not included in the Roamind profile.

This caused a lot of frustration,  until a while ago the only solution was
to have logon/logoff scripts that would copy the files over to a roaming
location.
But Microsoft heard the complaints and they silently released an update to
address this.
You are now able to move the QAT files to the roaming part of your profile
through the following steps

   - Request the hotfix http://support.microsoft.com/kb/955142/?FR=1 *(JK Or
   Service Pack 2 is later fix*)
   In most cases this update is already installed, so you probably don't
   need it.
   - Change the Registry, so that the hotfix will become active, use one of
   the following three solutions
    - Install the ADM or ADMX template which you can find at
      http://blogs.platani.nl/downloads.php
      - If the System is not managed by policies you can change the
      following registry key for each user.
       - HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Toolbars
         - QuickAccessToolbarRoaming DWORD with a value of 1
      - In case that you are using policies you can change the following
      registry key, though i would advise you to use the ADM or ADMX instead.
       - 
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Common\Toolbars

         - QuickAccessToolbarRoaming DWORD with a value of 1 "


Of course the easiest solution for me was to download and use the
sensational group policy template by platoni which worked like a champ.
Links are below.

  Office QAT ADM file <http://blogs.platani.nl/tools/OfficeQAT-ADM.zip>

ADM file to set the right policy value when using the Office 955142
hotfix* (jk:
or Service Pack 2)* http://blogs.platani.nl/tools/OfficeQAT-ADM.zip
  Office QAT ADMX file

ADMX files to set the right policy value when using the Office 955142 hotfix
* (jk: or Service Pack 2)*
http://blogs.platani.nl/tools/OfficeQAT-ADMX.zip


We know how these items can "disappear from the web so here is the text from
the files so you can copy and paste and make your own.  First the Qat.admx
file:
--Start cutting below this--
<policyDefinitions revision="1.0" schemaVersion="1.0">
  <policyNamespaces>
    <target prefix="fullarmor"
namespace="FullArmor.Policies.AE30A6DE_AC2C_4094_926E_DCB7FD970712" />
    <using prefix="windows" namespace="Microsoft.Policies.Windows" />
  </policyNamespaces>
  <supersededAdm fileName="c:\windows\inf\officeqat.adm" />
  <resources minRequiredRevision="1.0" />
  <supportedOn>
    <definitions>
      <definition name="SUPPORTED_WIN2K"
displayName="$(string.SUPPORTED_WIN2K)" />
      <definition name="SUPPORTED_NotSpecified"
displayName="$(string.ADMXMigrator_NoSupportedOn)" />
    </definitions>
  </supportedOn>
  <categories>
    <category name="OFFQAT" displayName="$(string.OFFQAT)" />
  </categories>
  <policies>
    <policy name="EnableRoamingQAT" class="User"
displayName="$(string.EnableRoamingQAT)"
explainText="$(string.EnableRoamingQAT_EXP)"
presentation="$(presentation.EnableRoamingQAT)"
key="Software\Policies\Microsoft\Office\12.0\Common\Toolbars"
valueName="QuickAccessToolbarRoaming">
      <parentCategory ref="OFFQAT" />
      <supportedOn ref="SUPPORTED_WIN2K" />
      <enabledValue>
        <decimal value="1" />
      </enabledValue>
      <disabledValue>
        <decimal value="0" />
      </disabledValue>
    </policy>
  </policies>
</policyDefinitions>
---Stop cutting above here--

And here is the test from Qat.adm file
--Start cutting below this--
#if version <= 2
CLASS USER
CATEGORY  !!GPONLY_CAT
    POLICY !!GPONLY_POL
        KEYNAME Software\Policies
        PART !!GPONLY_TEXT1 TEXT
        END PART
        PART !!GPONLY_TEXT2 TEXT
        END PART
    END POLICY
END CATEGORY
CLASS MACHINE
CATEGORY  !!GPONLY_CAT
    POLICY !!GPONLY_POL
        KEYNAME Software\Policies
        PART !!GPONLY_TEXT1 TEXT
        END PART
        PART !!GPONLY_TEXT2 TEXT
        END PART
    END POLICY
END CATEGORY
#endif; version <= 2
#if version >= 3
CLASS MACHINE
CLASS USER
CATEGORY !!OFFQAT
 KEYNAME Software\Policies\Microsoft\Office\12.0\Common\Toolbars
 POLICY !!EnableRoamingQAT
  VALUENAME QuickAccessToolbarRoaming
  VALUEON NUMERIC 1
  VALUEOFF NUMERIC 0
  EXPLAIN !!EnableRoamingQAT_EXP
  #if version >= 4
  SUPPORTED !!SUPPORTED_WIN2K
  #endif
  END POLICY
END CATEGORY ;GENERAL
#endif
[strings]
; GPONLY
GPONLY_TEXT1="System Policy Editor does not support this policy template."
GPONLY_TEXT2="You must use Group Policy in Windows 2000."
GPONLY_CAT="Unsupported Administrative Template"
GPONLY_POL="OfficeQAT.ADM"
; SUPPORTED
SUPPORTED_WIN2K="At least Microsoft Windows 2000"
; CATEGORIES
OFFQAT="QAT files."
; CATEGORY EXPLANATIONS
OFFQAT_EXP="QAT files."
; POLICIES
EnableRoamingQAT="Change the default location of QAT files."
; PARTS
; POLICY EXPLANATIONS
EnableRoamingQAT_EXP="This setting let's you change the default location of
your QAT files in Office 2007, so they are included in the roaming
profiles."
---Stop cutting above here--

Jim Kenzig
http://www.kenzig.com

Other related posts:

  • » [THIN] Tip: Fixing quick access toolbar in Office 2007 to save when using roaming profiles - Jim Kenzig