conversion of lotus 123 files to excel

R

Reeka

What is the best way to convert Lotus 123 files to Excel
97. Please explain in both how to do in excel or in Lotus
123
thanks
Reeka
 
G

Gord Dibben

Reeka

From Help Answer Wizard "lotus 123"

About opening and saving files from other programs
Some of the content in this topic may not be applicable to some languages.

You can open a file created in another program, such as Lotus 1-2-3 or Quattro
Pro, in Microsoft Excel the same way you would open an Excel file. You can
then save the file in its original file format or as an Excel workbook using
the standard Excel save commands. Files saved as Excel workbooks might not
retain all of their original formatting, and features and formatting of an
Excel 2002 workbook might not be available in other programs.

Changing the default file format for saving workbooks

If you work with others who use earlier versions of Excel or other spreadsheet
programs, you can change the default file format used to save workbooks you
create in Excel 2002.

Supported Lotus 1-2-3 and Quattro Pro versions

Excel can directly open files from Lotus 1-2-3 versions up through 4.0 (*.wk?)
and Quattro Pro for Windows versions 5.0 and 7.0 by using the Quattro Pro
converter. To open a file from a later Quattro Pro version in Excel, either
save the file in an earlier Quattro Pro format, or save the file in another
format, such as Lotus 1-2-3 (*.wk?). Although you can open Quattro Pro for
MS-DOS and Quattro Pro for Windows files, there are some limitations to
opening the worksheets.

If you didn't install the converter for Quattro Pro files when you installed
Excel, you must install it before you can open files in that format. You can't
use the Quattro Pro file converter to save files. You will need to install the
Quattro Pro converters from the Microsoft Office Web site.

Note The hyperlink in this topic goes to the Web. You can switch back to
Help at any time.

Password protected files

Excel 2000 and later versions can open password protected WKS and WK1 files
and files that are protected at the worksheet level. Excel 2000 and later
versions cannot open WK3 or WK4 files that are protected with a file-level
password. Excel 2000 and later versions cannot open Quattro Pro files that are
password protected. Before you open the file in Excel, make sure you have
removed any password from the file.

Gord Dibben Excel MVP
 
L

Lady Layla

In Lotus, open file, save as <file name>.wk4
remember file name and path

In Excel, File Open Type of file (Lotus files .wk*) manuever to the file in
question


: What is the best way to convert Lotus 123 files to Excel
: 97. Please explain in both how to do in excel or in Lotus
: 123
: thanks
: Reeka
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top