Excel - Template Wizard with Data Tracking - Excel 2007 compatibility

Asked By Janic on 13-Mar-09 03:09 PM
I just updated from Excel 2003 to 2007 and want to use the Template Wizard
with Data  Tracking to build a database.  I downloaded it from Microsoft and
installed it but now I can't find it anywhere (including the Add-In list) in
Excel 2007.  Is this wizard compatible with 2007? Has it been replaced by
something else?




Gord Dibben replied on 13-Mar-09 08:19 PM
The Template Wizard with Data Tracking works with 2007.

Have you downloaded the executable from the MS site?

http://support.microsoft.com/kb/873209/en-us

When you run the TMPLWIZ.EXE it does its thing but you can't find the
WZTEMPLT.XLA ?

Same thing happens with Excel 2003.

See this google search thread before proceeding.

http://tinyurl.com/2uxmud

You can email me to get a copy per the instructions in the google thread.


Gord Dibben  MS Excel MVP


On Fri, 13 Mar 2009 12:09:02 -0700, Janice
Alan McDonald replied to Janic on 17-Oct-10 11:26 PM
To the best of my knowledge the program is not longer supported by Microsoft.  You can however, save the files in 2003 format and use the TW that way.  It works but is not what I consider the easiest way to work with it.



I am in a state of shock that MS would not continue using this most wonderful add-in and one that is, as far as I am concerned, one of the better creations that ever came out of Microsoft.  Shame on those guys for dropping an add-in that really showed how powerful Excel can be with such a great add-in.