XL5 Err Msg: "File Format No Longer Supported" Creating Add-in

 Last reviewed: September 13, 1996
Article ID: Q124180
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0, 5.0c
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you create an add-in, you may receive the following error message: 

   File format no longer supported
When you choose OK, you receive the following error message: 

   Document not saved

CAUSE

This behavior occurs when you create an add-in with the same name as an existing add-in and you choose to overwrite the existing add-in while a module that references this add-in is open. For example, if you reference BOOK1.XLA in a module in BOOK2.XLS, you cannot create a new add-in called BOOK1.XLA while BOOK2.XLS is open.

Note that this behavior occurs only if the add-in that you are creating contains different information than the existing add-in, even if it is just a modified version of the existing add-in. Because you cannot open an add- in for editing, creating an add-in with the same name as an existing add-in is the only way to "modify" the add-in.

If you open an add-in file either by using the Open command, or by using a Visual Basic procedure, and you then use the Make Add-In command to create an add-in with the same name as the open add-in, you receive the following error message: 

   Cannot save this file with the same name as an open document
To stop this error message from being displayed, close Microsoft Excel.

WORKAROUND

To avoid receiving this error message when you create an add-in file, close any workbooks that contain a module that references the add-in that you are creating.

MORE INFORMATION

In Microsoft Excel versions 5.0 and 5.0c, you cannot open an add-in for editing. When you open an add-in file while holding down the SHIFT key, you receive the following error message: 

   Cannot open Microsoft Excel 5.0 Add-In for editing. Please edit the
   source document instead.
After you edit the source document, you can use the Make Add-In command (Tools menu) to update the add-in file with your changes. However, if a module that references the add-in is open, you receive the error messages described above.

REFERENCES

For more information about the Make Add-in Command (Tools Menu), choose the Search button in Help and type: 

   add-ins

KBCategory: kbprg kberrmsg
KBSubcategory:

Additional reference words: 7.00 5.00 5.00c addins



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: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.