XL: New Workbooks Open Repeatedly Starting Excel

ID: Q136874

The information in this article applies to:

SYMPTOMS

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


CAUSE

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

Normally, when you install Microsoft Excel 7.0, the Setup program removes these files if they are located in your Xlstart folder. However, the Microsoft Excel Setup program 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), the Microsoft Excel 7.0 Setup
   program 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, the Microsoft Excel 7.0 Setup
   program 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, the Microsoft Excel Setup program does not detect the earlier version of Microsoft Excel on your computer, and does not remove the files.


RESOLUTION

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


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 the Microsoft fee-based consulting line at (800) 936-5200. 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/refguide/

For information about versions of these files that will be compatible with Microsoft Excel for Windows 95, contact Delrina Technology.


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 above 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 will not work in Microsoft Excel 7.0 because it is designed for a 16-bit application.

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,97
Platform          : WINDOWS 
Issue type        :

Last Reviewed: May 17, 1999