Microsoft KB Archive/106361
XL5: Transition Formula Evaluation Uses AFE Setting
The information in this article applies to:
- Microsoft Excel for Windows, version 5.0
In Microsoft Excel version 5.0, the Microsoft Excel version 4.0 Alternate Formula Entry (AFE) option is renamed to Transition Formula Entry. The option is available in Microsoft Excel version 5.0 by choosing Options from the Tools menu and selecting the Transition tab.
The Transition Formula Entry option uses the following setting in the EXCEL5.INI file to specify whether or not the option should be turned on
where n is the value 0, 1, or 2. If n is 0, the Transition Formula Entry option will not be automatically turned on. If n is 1, the Transition Formula Entry option will be automatically turned on. If n is 2 (the default), the Transition Formula Entry option will be turned on only if a macro name exists on the the Lotus 1-2-3 worksheet that you open in Microsoft Excel.
You cannot substitute "AFE" with "TFE" in the above setting. "TFE" will have no affect on the Transition Formula Entry option when opening Lotus 1-2-3 worksheets.
"User[ASCII 146]s Guide," version 5.0, page 35
For more information about Specifying Lotus 1-2-3 Worksheet Settings, choose the Search button in Help and type:
Additional query words:
Keywords : kbprb
Version : 5.00
Platform : WINDOWS
Issue type :
Last Reviewed: April 9, 1999