Article ID: 198935
Article Last Modified on 8/6/2002
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q198935
SYMPTOMS
When you start Excel, you receive an error message similar to the following:
CAUSE
This behavior occurs when both of the following conditions are true:
- You added the Page Break button to your main toolbar.
-and- - You have one or more of the following add-ins installed:
Analysis ToolPakAnalysis ToolPak - VBAAutoSave
WORKAROUND
Move the Page Break button from your main toolbar to another toolbar. To do this, you must first rename the startup toolbar file.
In Microsoft Excel 97 for Windows, this file is named:
- Excel8.xlb, if your computer is not connected to a network or is not set up with a logon prompt.
-or-
Username
8.xlb, whereUsername
is your user logon name.
NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
To rename this toolbar file and modify your main toolbar, follow these steps:
- Click Start, point to Find, and then click Files or Folders.
- In the Named box, type *.xlb.
- Be sure the Look in box points to the root of your hard disk (usually drive C).
- Be sure the Include subfolders check box is selected.
- Click Find Now.
- After the file is found, right-click the file; click Rename on the shortcut menu, and name the file Test.xlb.
- Start Excel and load the Test.xlb file. (You can drag the file from the Find dialog box into Excel.)
- Create a custom toolbar and move the Page Break button from the main toolbar to the custom toolbar. You may place the toolbar anywhere you want.
- Quit and then restart Excel.
Excel should load successfully.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
REFERENCES
For additional information about toolbars, click the article numbers below to view the articles in the Microsoft Knowledge Base:
125183 XL: Default Toolbars and Toolbar Buttons Seen Instead of Customizations
161235 XL97: How to Use a Toolbar Settings File from a Network Share
Additional query words: XL97 ipf crash crashes crashing crashed quit quitting quits fail fails failing failed break
Keywords: kbbug kbpending KB198935