Help and Support

XL97: ValuPack Templates Not in Microsoft Excel 97 Format

Article ID:161792
Last Review:October 22, 2000
Revision:1.0
This article was previously published under Q161792

SYMPTOMS

When you save a document based on any of the templates that are stored in the Valupack\Template\Excel folder on the Microsoft Office 97 compact disc, you may receive the following alert message:
'<Template Name>' was created in a previous version of Microsoft Excel.
Do you want to update it to the new format?
Where <Template Name> is the name of the template you are using.
If you click Yes, the file is saved in the Microsoft Excel 97 file format.

Back to the top

CAUSE

This behavior occurs because the templates in the Valupack\Template\Excel folder on the Microsoft Office compact disc are not in the Microsoft Excel 97 file format; they are in the Microsoft Excel 5.0/95 file format.

Back to the top

RESOLUTION

To resolve this behavior, save the templates in the Microsoft Excel 97 file format before you use them.

The following steps show you how to open the Loan.xlt file and save it in Microsoft Excel 97 format.

1.Insert the Microsoft Office compact disc into your CD-ROM drive.
2.Start Microsoft Excel.
3.On the File menu, click Open.
4.In the Look In list, click the Microsoft Office compact disc.
5.In the File name box, type the following:
<Drive letter>\Valupack\Template\Excel
Where <Drive letter> is the CD-ROM drive letter.
For example, if your CD-ROM drive is drive D, type the following:
D:\Valupack\Template\Excel
A list of Microsoft Excel templates appears.
6.Click Loan, and then click Open.

If a message appears that warns you about macro viruses, click Enable Macros.

If a message about Visual Basic modules appears, click OK.
7.On the File menu, click Save As.
8.In the file name box, type C:\Program Files\Microsoft Office\Templates \Spreadsheet Solutions\Loan.xlt, and then click save.

The Loan.xlt template is saved in the Microsoft Excel 97 file format. Repeat these steps for additional templates that you want to convert.
9.Click Close on the File menu.
NOTE: The template, LOAN.XLT is an amortization schedule.

Back to the top

REFERENCES

For more information about templates, click the Index tab in Microsoft Excel Help, type the following text
templates
and then double-click the selected text to go to the "Guidelines for storing templates" topic.

Back to the top


APPLIES TO
Microsoft Excel 97 Standard Edition

Back to the top

Keywords: 
kbprb kbualink97 KB161792

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.