Enter your email address:

Delivered by FeedBurner

Home Page








Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Friday, August 29, 2008 – Permalink –

Template Wizard with Data Tracking

Add it back in

Add-ins are often replaced in new versions of Office. In Office 2000, Excel had a Wizard that would create an entry form and store information in a database.

To retrieve that function you need to add back the Template Wizard.

"The Microsoft Excel 2002 Template Wizard is an add-in program that sets up a database to store data entered from an Excel form. When you load the add-in program, the Template Wizard command is added to the Data menu in Excel."

When you download the WZTEMPLT.XLA, you must install it in the Office11 folder:
X:\Program Files\Microsoft Office\Office11\Library

How to install the Excel 2002 Report Manager add-in and Template Wizard add-in in Excel 2003 and 2007

The Wizard can be downloaded here:
Excel 2002 Add-in: Template Wizard with Data Tracking

(When you run the executable, be sure to change the destination to the Office11 folder, if you are using Office 2003, Office 12 for 2007.)

How to use the Template Wizard with the Data Tracking add-in
Also see:
Report Manager

See all Topics


<Doug Klippert@ 3:34 AM

Somehow Microsoft finds the most obtuse way of doing things. When you download the xla file, save it to your desktop.

Open Tools AddIns and select browse. Click on desktop file. Windows will ask if you want to add it....duh

Voila, easier than their method of searching folders for the templates folder.
Hope this helps

Post a Comment