Microsoft KB Archive/170939
Article ID: 170939
Article Last Modified on 10/22/2000
- Microsoft Excel 97 Standard Edition
This article was previously published under Q170939
If you press HOME, you may receive the following error message:
If you click Details, you receive an error message similar to the following:
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.
To resolve this problem, begin the formulas by typing the equal sign (=) instead of clicking the equal sign (=) in the formula bar.
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.
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.
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