To correct this problem, use any of the following methods:
- Method 1: Reset the Excel toolbar information file.
- Method 2: Remove the Page Break command from the Worksheet Menu Bar.
- 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:
- Click Start, click Run, click Browse in the Open box, and then locate the Excel.exe file.
By default this will be located in the following folder:c:\program files\microsoft office\office\
- Click the Excel.exe file, and then 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 that contains custom toolbar settings is stored in the "C:\Windows\Application Data\Microsoft\Excel" folder and is named one of the following:
- Excel.xlb, if your computer is not connected to a network or is not set
up with a logon prompt.
- Username.xlb, where Username is your user log on 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 put 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.