Article ID: 170939
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q170939
SYMPTOMS
If you press HOME, you may receive the following error message:
If you click Details, you receive an error message similar to the following:
CAUSE
This problem occurs if all of the following conditions are true:
- The Transition Navigation Keys check box is selected on the Transition tab in the Options dialog box. -and-
- You click the equal sign (=) in the formula bar to begin a formula. -and-
- After you enter the formula, you press HOME.
RESOLUTION
To resolve this problem, begin the formulas by typing the equal sign (=) instead of clicking the equal sign (=) in the formula bar.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.
MORE INFORMATION
Microsoft Excel 97 has a new feature called the Formula Palette. When you create a formula that contains a function, the Formula Palette helps you enter worksheet functions. As you enter a function into the formula, the Formula Palette displays the name of the function, each of its arguments, a description of the function and each argument, the current result of the function, and the current result of the entire formula. To display the Formula Palette, click Edit Formula (the equal sign) in the formula bar.
REFERENCES
For more information about the Formula Palette, click the Office Assistant, type formula palette, click Search, and then click to view "About using the Formula Palette to enter and edit formulas."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
Additional query words: XL97 ipf crash
Keywords: kberrmsg kbprb KB170939