Microsoft KB Archive/106361

{|
 * width="100%"|

XL5: Transition Formula Evaluation Uses AFE Setting

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SUMMARY
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

  AFE=n

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.