• UseTemplate Add-in

    Templates Addin
    This addin was created to increase the functionality of Excel, and make it easier to use templates in the MS Office system. I use a lot of templates, and got tired of having to make up to six clicks to open one. Now, I have a menu that holds all of my MS Office templates (not just Excel), only three clicks away.

    • Adds a menu to hold all Excel, Word and Powerpoint templates.
    • Open any MS Office template right from Excel. (No more guessing what application you built it in!)
    • Adds a separate submenu for each folder in your templates directory to keep them organized.
    • Groups all templates in your root templates directory in one folder.
    • Supports both network and local templates.
    • Allows you to change your template directory from Excel. (Previously only available through Word.)
    • Toggle button to switch between Edit and Normal modes. (Edit mode opens template for editing, normal creates a new document based on the template.)

    Versions Supported:
    Excel 97, 2000, 2002(XP) and 2003.

    Screen Shot:

    The download package includes the latest version of the UseTemplate add-in, as well as three (very bare bones) sample templates so that you can test the application.

    The current release, (v1.007 from May 3, 2007,) can be downloaded by clicking the button below:


    For a complete set of instructions on how to install and use this add-in, please visit the UseTemplate Add-in Instruction page.

    I'd like to thank Bob Phillips of www.xldynamic.com for helping me make this file compatible with Excel 97.
    Also, I'd like to thank my beta testers for putting this through some paces for me. They are:
    • Zack Barresse
    • Steve Lucas
    • Matt Vidas


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts


    Power Query From Table Or Range Error

        Source = Excel.CurrentWorkbook(){[Name="tblJobs"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Status",

    TamTam Yesterday, 07:26 PM Go to last post
    Ken Puls

    Power Query From Table Or Range Error

    Hi TamTam,

    Is it possible to post the M code of your query here?

    • Go to Power Query -> View -> Advanced Editor and copy all

    Ken Puls Yesterday, 05:59 PM Go to last post

    Editing My Posts

    You don't see the markup when you click on EDIT? You won't see it in the saved message or preview. Still not quite sure what you mean.


    AliGW Yesterday, 05:51 PM Go to last post
    Bob Phillips

    Editing My Posts

    No, nor do I. I just see the formatted output not the markup code. That is exactly the problem..

    No, I really do not need any more 3rd party...

    Bob Phillips Yesterday, 04:44 PM Go to last post

    Power Query From Table Or Range Error

    I have seemingly randomly started getting an error message with some of my Power Queries that reads as follows:

    The command " isn't...

    TamTam Yesterday, 02:19 PM Go to last post