Something I’ve noticed consistently at many Clarity 6 clients is that the Clarity Administrator and others responsible for building templates and reports get stuck with the Template Builder loading (slowly) every time they open Excel. I use the template building ½ the time and I still find this annoying – I can only imagine how those who use it only a few times a month or year feel.
With Clarity 7 this is no longer an issue as Studio is a separate product and no longer attached to Excel. There are still however many Clarity 6 clients out there who I’m sure would like to remove the template builder, but then also add it back when required.
Good news – with a minor tweak to your registry this can easily be accomplished. Excel stores all the Add-ins load behaviour in a registry setting, changing this setting to 0 causes the builder not to load while still keeping the product installed for later use!
We have even created a couple of files you can use to place on your Desktop that will make the modifications for you. You can find these files on the Resource page of our site, but they’re not large so I’m also going to include the contents and instructions below.
File Instructions – Disabling the Template Builder
1. Copy the following into a notepad exactly as shown and save it as DisableCTB.reg.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\AddIns\CTB.Connect]
"LoadBehavior"=dword:0
2. Double-Click the file
3. Answer Yes to the “Are you sure” prompt
File Instructions – Enabling the Template Builder
1. Copy the following into a notepad exactly as shown and save it as EnableCTB.reg.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\AddIns\CTB.Connect]
"LoadBehavior"=dword:1
2. Double-Click the file
3. Answer Yes to the “Are you sure” prompt
Manual – Updating Registry
1. Open the registry using RegEdt32 or RegEdit and find the following node:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\AddIns\CTB.Connect
2. Change the DWORD entry for LoadBehavior to:
– 0 to Disable
– 1 to Enable
3. Save your changes
Security Note: Some readers may find that they do not have Write access to their local registry, in which case you many need to ask IT to assist.