XL2000: Page Fault Starting Excel with Page Break Menu Command

ID: Q215366

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you start Microsoft Excel, 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 the following:

Excel caused an invalid page fault in module Excel.exe at 015f:300a8487.

CAUSE

This problem occurs when you do the following:

You add the Page Break command directly to the Worksheet Menu Bar (not to a menu).

-and-

You have an add-in loaded.

WORKAROUND

To correct this problem, use any of the following methods:

Method 1: Reset the Excel toolbar information file.

-or-
Method 2: Remove the Page Break command from the Worksheet Menu Bar.

-or-
Method 3: Unload all add-ins.

To implement methods 2 and 3, you must first be able to open Microsoft Excel without error messages. To run Excel without receiving the invalid page fault, use the /automation switch when starting Excel. To do this, follow these steps:

On the Start menu, click Run.

In the Open box click Browse. In the Browse dialog box, navigate to the file Excel.exe.

By default this will be located in the following folder:

c:\program files\microsoft office\office\

Click the Excel.exe file and click Open.

In the Run dialog box, type /automation after the path as in the following example:

c:\program files\microsoft office\office\excel.exe /automation
Note the space between excel.exe and /automation.

Click OK to run Excel.

Method 1: Reset the Excel Toolbar File

The file which contains custom toolbar settings is stored in the "C:\Windows\Application Data\Microsoft\Excel" folder and is named:

Excel.xlb, if your computer is not connected to a network or is not set up with a logon prompt.

-or-
Username.xlb, where Username is your user logon name.

Using Microsoft Explorer, rename this file to Test.xlb. Then, start Excel and open the Test.xlb file. Create a custom toolbar, and move the Page Break button from the Worksheet Menu Bar to the Custom toolbar. You may place the toolbar anywhere you want. Then, quit and restart Excel to save the changes to the toolbar.

Method 2: Remove the Page Break Command

NOTE: This problem only occurs when you place the command directly on the Worksheet Menu Bar (not on a menu). You can successfully start and run Excel with the command on any other toolbar. For example, place the Page Break command on the Standard instead.

On the Tools menu, click Customize.

In the Customize dialog box, right-click the Page Break command on the Worksheet Menu Bar and click Delete.

In the Customize dialog box, click Close.

Method 3: Unload All Add-ins

If you are not using any add-ins, you may unload them instead of removing (or moving) the Page Break command from the Worksheet Menu Bar. To do this, follow these steps:

On the Tools menu, click Add-Ins.

In the Add-Ins dialog box, click to clear (remove the check mark) for all the add-ins listed, and click OK.

STATUS

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

MORE INFORMATION

The Page Break command is available on the Insert menu of the Worksheet Menu Bar. You can add or remove any commands on a menu or toolbar (collectively referred to as command bars). However, if you add the Page Break command to the Worksheet Menu Bar and you have add-ins loading, Excel will not start but display a page fault error message.

REFERENCES

For additional information on toolbars, please see the following article in the Microsoft Knowledge Base:

Q214284 XL2000: Default Toolbars, Buttons Seen, Not Customizations

Additional query words: XL2000

Keywords : kbdta xladdins xltoolbar
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug