Overview
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 install the add-in
program, the Template Wizard command is added to the Data menu in Excel.
Note Although it was not necessary to download this
add-in with previous versions of Excel (it was shipped with the product),
you must download it here in order to use it with Excel 2002.
Top of page
System requirements
Supported operating systems: Windows 2000, Windows 98, Windows ME, Windows NT
- This download works with the following Office applications:
Top of page
Instructions
To install this download
- You may want to print this page to use as a reference when you are
offline.
- Quit Excel if it's running.
- Download the file from the Microsoft Office Tools
on the Web site by clicking the Download link above and following the instructions in
the dialog boxes.
- Double-click the tmplwiz.exe program file on your hard disk to
start the setup program.
- Follow the instructions on the screen to complete the installation.
- Start Excel.
- On the Tools menu, click Add-ins.
- Select the Template Wizard with Data Tracking check box.
Instructions for use:You can use the Excel 2002 Template Wizard with any worksheet form that has cells
designated for data entry. The wizard links cells in your form template —
a workbook that you create and use as the basis for other similar workbooks — to fields in the database that it creates for you. When a user creates a new
workbook from the template, enters data in the linked cells, and then saves
the workbook, Excel creates a new record in the database containing the data
from the form.
To remove this download:
- Start Excel.
- On the Tools menu, click Add-Ins.
- Clear the Template Wizard with Data Tracking check box.
Top of page