Cannot Save as Add-in or Template for Previous Version

Last reviewed: August 25, 1995
Article ID: Q85015
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY

In Microsoft Excel, you cannot save a sheet to the add-in or template file format for a previous version of Microsoft Excel. For example, in Microsoft Excel 5.0, you cannot save a sheet to the add-in or template file format for Microsoft Excel version 3.0 or 4.0.

MORE INFORMATION

In Microsoft Excel, you can save a macro sheet as an add-in file (*.XLA). You can also save a worksheet, chart or macro sheet in the template file format (*.XLT).

However, you cannot save a sheet in the add-in or template file format for an earlier version of Microsoft Excel. When you save a sheet to the add-in or template file format, the saved file can only be opened in the Microsoft Excel version in which it was saved. This is by design.

To save a file to the add-in or template file format for a particular version of Microsoft Excel, you must open the file in that version and then save the file.

REFERENCES

"User's Guide," version 5.0, page 42 "User's Guide 1," version 4.0, pages 60, 81-82 "User's Guide 2," version 4.0, pages 292-293


KBCategory: kbusage kbtool
KBSubcategory:

Additional reference words: 5.00 5.0 4.00 4.0 3.00 3.0


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 25, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.