In Microsoft Excel 97 there is a new feature called a report template. A
report template is a Microsoft Excel template that includes one or more
queries or PivotTables based on external data. When you save a report
template, the external data is not stored in the template. Instead, the
data is refreshed each time you open the report template.
To create a report template:
- Open the workbook that contains the queries or PivotTables that are
based on external data.
NOTE: For more information about creating a PivotTable, or retrieving data from external sources, see the "References" section later in this article.
- On the File menu, click Save As.
- In the Save as type list, click Template(*.xlt).
- in the File name box, type a name for the template.
NOTE: The destination folder for the template must be either the
\Program Files\Microsoft Office\Templates or \Program Files\Microsoft
Office\Templates\Spreadsheet Solutions folder. These folders are the
default Templates folders. However, the default Template folders on your
computer may be different depending on where you installed Microsoft
- Click Save.
The following message appears:
This workbook contains external data. Do you want Microsoft Excel to
clear the data before saving the template, and then automatically
refresh the data whenever the template is opened?
- Click Yes to create the Report template.
If you click Yes, the file is saved as a report template, and the
external data is not stored in the file. If you click No, the
file is saved as a normal template, and the external data is saved in
the file. If you click Cancel, the save process is canceled and
you receive the following message:
- On the File menu, click Close.
- On the File menu click New.
The report template appears on the General tab or the
Spreadsheet Solutions tab in the New dialog box, depending
on the location in which you saved the file in step 5.
- Click the report template you saved, and then click OK.
Microsoft Excel opens a copy of the template that contains the updated
You can also open the template file directly in Microsoft Excel to refresh
and display the external data.
Because the report template removes the external data from the file when
you save and close the file, it is smaller in size and secure from users
who may not have access to the data source. By default, a template that is
not a report template stores all of the data in the file that is based on
For more information about creating a PivotTable, click Contents and Index
on the Help
menu, click the Index
tab in Excel Help, type the following text
and then double-click the selected text to go to the "Create a PivotTable"
topic. If you are unable to find the information you need, ask the Office Assistant.
For more information about retrieving data from external sources, click Contents and Index
on the Help
menu, click the Index
tab in Excel Help, type the
external data sources, retrieving data
and then double-click the selected text to go to the "Ways to retrieve data from an external database"
you are unable to find the information you need, ask the Office
Article ID: 156449 - Last Review: April 18, 2003 - Revision: 1.1
- Microsoft Excel 97 Standard Edition
|kbfaq kbhowto kbualink97 KB156449|Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.