Microsoft KB Archive/168201

= XL97: Error Messages Appear Clicking Options on Tools Menu =

Article ID: 168201

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q168201



SYMPTOMS
When you click Options on the Tools menu in Microsoft Excel 97, you may receive the following error message:

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

If you click Details, you receive an error message similar to either of the following:

EXCEL caused an invalid page fault in module EXCEL.EXE at 014f:300ce93a.

EXCEL caused an invalid page fault in module at 0000:00780078.

Also, when you click OK in the Options dialog box, you may receive an error message similar to any of the following:

EXCEL caused a stack fault in module EXCEL.EXE at 014f:300cc4c7.

EXCEL caused an invalid page fault in module at 0000:00000078.

EXCEL caused an invalid page fault in module EXCEL.EXE at 014f:300cc4c7.

EXCEL caused an exception 01H in module EXCEL.EXE at 014f:300c0001.



CAUSE
These problems occur if you click Options on the Tools menu, click the General tab, and then specify a path that exceeds 53 characters in the Default File Location box.



WORKAROUND
To work around this problem, make sure that the path does not exceed 53 characters when you type a path in the Default File Location box.

If you already specified a path that exceeds 53 characters in the Default File Location box, do the following:


 * 1) If Microsoft Excel 97 is running, quit the program.
 * 2) Using Windows Explorer, locate the folder that you specified in the Default File Location box. Click the folder to select it.
 * 3) Right-click the folder and click Rename on the shortcut menu. Change the folder name, and then press ENTER.
 * 4) Start Microsoft Excel 97. On the Tools menu, click Options.

NOTE: If the problem still occurs, you may have renamed the wrong folder. Repeat steps 1-4 and use a different folder.
 * 1) Click the General tab.

The path in the Default File Location box should be C:\My Documents. You can specify any folder in the Default File Location box, however, make sure that the length of the path does not exceed 53 characters.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.



MORE INFORMATION
In Microsoft Excel 97, you can set the default file location for Microsoft Excel files by doing the following:

 On the Tools menu, click Options. Click the General tab.  In the Default File Location box, type the path that you want Microsoft Excel 97 to use, for example:      C:\My Documents\Workbooks

-or-

     \\Server\Share\CJUser\MyWorkbooks  When you are done, click OK.

When you display the Open or Save As dialog box, Microsoft Excel 97 uses the path you specified by default in the Default File Location box.

Note that the problems described in this article do not occur when you open or save a workbook; they occur only when you use the Options dialog box.

Additional query words: XL97

Keywords: kberrmsg KB168201

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.