XL98: How to Create a Report Template
ID: Q185040
|
The information in this article applies to:
-
Microsoft Excel 98 Macintosh Edition
SUMMARY
In Microsoft Excel 98 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 that are based on external data. When you save a
report template, the external data is not stored in the template. Instead,
the data is updated (refreshed) each time you open the report template.
MORE INFORMATION
To create a report template, follow these steps:
- Open the workbook that contains the queries or PivotTables that are
based on external data.
- On the File menu, click Save As.
- In the Save As Type list, click Template.
- In the File Name box, type a name for the template.
NOTE: The destination folder for the template must be either the
<hard disk>:Microsoft Office 98:Templates or <hard disk>:Microsoft
Office98:Templates:Spreadsheet Solutions folder. These folders are the
default Templates folders. However, the default Template folders on your
computer may be different depending on the folder in which you installed
Microsoft Office.
- 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:
Document not saved
- 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
external data.
You can also open the template file directly in Microsoft Excel to update
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
the template.
REFERENCES
For more information about report templates, click Contents And Index on
the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
report templates
and then click Show Topics. Select the "Create a template to share external
data" topic, and click Go To. If you are unable to find the information you
need, ask the Office Assistant.
Additional query words:
odbc query data source XL98
Keywords : kbualink97 kbdta xlloadsave xltemp xlquery
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto
|