XL5: Transition Formula Evaluation Uses AFE Setting

ID: Q106361

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.

REFERENCES

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

EXCEL5.INI file

Additional query words:

Keywords : kbprb
Version : 5.00
Platform : WINDOWS
Issue type :