old lotus files

  • Thread starter Thread starter marty
  • Start date Start date
Most Lotus files will be understood by Excel. Just try.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Marty,
Excel will read old Lotus .WK? files. In Excel, just do a File/Open and
then scroll down the Files of Type to Lotus 1-2-3 Files. Find the file you
want to open and open it. If your Lotus files are of the newer .123 format,
Excel will not open them. To handle this situation, open Lotus 1-2-3 and
save the file(s) in .WK4 format. You must save the file in WK4 format in
Lotus, it is not sufficient to just change the extension. Then you can open
the WK4 files in Excel. Be prepared to do some reformatting & formula and
macro updating after opening the file in Excel.
Jim Orson...
 
Jim Orson said:
. . . If your Lotus files are of the newer .123 format,
Excel will not open them. To handle this situation, open Lotus 1-2-3 and
save the file(s) in .WK4 format. . . .
Click to expand...

Better to save in .XLS format from 123. All versions of 123 that can read
..123 files can write .XLS (XL5/95 at least) files. 123R9.5 introduced a new
..123 format that provides 65,536 rows per worksheet. If that sort of .123
files are saved as .WK4 files rather than .XLS files, all data in rows 8,193
and further down would be lost.
 
Uh... what if you don't have Lotus anymore? I'm helping a
friend whose hard drive crashed and he doesn't have the
original software install disks (or cd). We'd really
rather not go out and buy a new copy of Lotus to do this.

Is there a file converter available anywhere???

Thanks,

Larry
 
Uh... what if you don't have Lotus anymore? I'm helping a
friend whose hard drive crashed and he doesn't have the
original software install disks (or cd). We'd really
rather not go out and buy a new copy of Lotus to do this.

Is there a file converter available anywhere???
Click to expand...

If you don't have 123 any more, you are screwed. No sense sugar coating
this.

There is *NO* free software that works with .123 files.

There is nothing from Microsoft that works with .123 files. [The .123 file
format has now been out for more than 6 years. If Microsoft were ever going
to have provided tools to read such files, they would have done so already.]

The only know software packages that can read and convert .123 files into
any other file format are
- Lotus 123 itself (no surprise)
- Corel Quattro Pro 10 and 11
- DataViz ConversionPlus (which I haven't used in the last 6 years).
All of these are commercial software, so you or your friend is going to have
to buy one of these if you want to do anything useful with these .123 files.
You don't have any alternative.

I'd guess 'used' copies of Quattro Pro 10 (in WordPerfect Office 2002) would
be the cheapest of all these alternatives, but 'used' copies of SmartSuite
may not be much more expensive.
 
Back
Top