

When checked, this option causes Excel to open and evaluate 1-2-3 files without losing or changing information. Notice the two options under Sheet Options these are what you need to work with: Make sure the Transition tab is displayed. The Transition tab of the Options dialog box.

(See Figure 1.) Choose Options from the Tools menu to display this dialog box.įigure 1. These settings are available from the Options dialog box. If you have some old 1-2-3 files and you want to make sure that they are treated, in Excel, according to Lotus 1-2-3 "rules," there are a couple of settings you need to pay attention to. One that it will open is spreadsheets originally created in Lotus 1-2-3. You probably already know that Excel will easily open a wide variety of spreadsheets stored in other formats.
