Microsoft KB Archive/106361

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:08, 20 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 :
Technology :

Last Reviewed: April 9, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.