XL: New Workbooks Open Repeatedly Starting Excel

ID: Q136874


The information in this article applies to:
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows


SYMPTOMS

When you start Microsoft Excel, new workbooks may open repeatedly until Microsoft Excel runs out of memory.


CAUSE

This behavior occurs if the Msexcel4.xlm file, installed by WinFax Pro version 4.0, is located in your Xlstart folder. WinFax Pro installs this file along with the Msexcel5.xls file, so that you can fax worksheets directly from within Microsoft Excel.

Normally, when you install Microsoft Excel 7.0, Setup removes these files if they are located in your Xlstart folder. However, Setup does not remove these files under the following conditions:

  • If you install Microsoft Excel 5.0, and then install WinFax Pro, and then install Microsoft Office Preview Program (whether you remove the Office Preview Program or not), Microsoft Excel 7.0 Setup does not remove the files from your Xlstart folder.

    -or-

  • If you install Microsoft Excel 5.0, and then install WinFax Pro, and then remove Microsoft Excel 5.0, Microsoft Excel 7.0 Setup does not remove the WinFax files from your Xlstart folder.

    -or-

  • If you install WinFax Pro after installing Microsoft Excel 97, the Microsoft Excel or Microsoft Office Setup program does not remove the WinFax files from your Xlstart folder.
In all of these cases, the WinFax Pro files, Msexcel4.xlm and Msexcel5.xls, are located in the Microsoft Excel Xlstart folder; however, Microsoft Excel Setup does not detect the earlier version of Microsoft Excel on your computer, and does not remove the files.


RESOLUTION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Solution Provider or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Solution Providers, please see the following page on the World Wide Web:

http://www.microsoft.com/mcsp/
For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp
To resolve this problem, remove both the Msexcel4.xlm and Msexcel5.xls files from the Xlstart folder.

Note that if you experience this problem, you will have a large number of workbooks open in Microsoft Excel. When you close Microsoft Excel, you can avoid being prompted to save the changes in these workbooks by running the following Visual Basic for Applications macro:

Sub MyExit()
    Application.DisplayAlerts = False
    Application.Quit
End Sub 
For information about versions of these files that will be compatible with Microsoft Excel for Windows 95, contact Delrina Technology.

For information about how to contact Delrina Technology, click the appropriate article number below to view the article in the Microsoft Knowledge Base:
Q65416 Hardware and Software Third-Party Vendor Contact List, A-K

Q60781 Hardware and Software Third-Party Vendor Contact List, L-P

Q60782 Hardware and Software Third-Party Vendor Contact List, Q-Z


STATUS

This problem occurs when you use Microsoft Excel version 7.0 for Windows 95 and WinFax Pro version 4.0. This problem was corrected in Microsoft Office versions 7.0a and 7.0b for Windows 95.

This problem also occurs when you use Microsoft Excel 97 if you place the WinFax files in the Xlstart folder after you install Microsoft Excel 97.


MORE INFORMATION

The macros contained in the WinFax Pro files Msexcel4.xlm and Msexcel5.xls are not compatible with Microsoft Excel version 7.0 or Microsoft Excel 97.

The problem described earlier also occurs if you open the Msexcel4.xlm file in Microsoft Excel, even if the file is not located in the Xlstart folder. The Msexcel5.xls file does not affect Microsoft Excel 7.0; however, it does not work in Microsoft Excel 7.0 because it is designed for a 16-bit program.

WinFax Pro is manufactured by Delrina Technology, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.


REFERENCES

Xlreadme.txt, Microsoft Excel for Windows 95, version 7.0, Microsoft Excel folder

Additional query words: multiple startup sheet 8.00 97 xl97

Keywords : xlloadsave xlwin
Version : WINDOWS:7.0
Platform : WINDOWS
Issue type :


Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.