XL97: How to Create a Report Template

MORE INFORMATION

1. 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.
2. On the File menu, click Save As.
3. In the Save as type list, click Template(*.xlt).
4. 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 Office.
5. 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?
6. 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:
   Document not saved
7. On the File menu, click Close.
8. 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.
9. Click the report template you saved, and then click OK.
   
   Microsoft Excel opens a copy of the template that contains the updated external data.