Open Lotus 123 file in Excel

Wirlybird · May 28th, 2002, 04:40 PM

Using Excel in Office 2000, I am trying to open a Lotus 123 file (.wk1 is the extention). I select *.wk? in the "file type" window and select the file I want to open. I then get the error "cannot open Lotus 123 file.
Thanks for any thoughts.

[ This Message was edited by: Wirlybird on 2002-05-28 13:23 ]

Jack in the UK · May 28th, 2002, 08:35 PM

I would suggest if version 123 Year 97 or above, save as Xls.. and open then..

Or save each sheet ir correct sheet as CSV and import into excel and re build..

These ideas should work OK long time sine I used 123 suite 97.

Jack in the UK · May 28th, 2002, 08:35 PM

I would suggest if version 123 Year 97 or above, save as Xls.. and open then..

Or save each sheet ir correct sheet as CSV and import into excel and re build..

These ideas should work OK long time sine I used 123 suite 97.

Wirlybird · May 28th, 2002, 08:46 PM

Thanks for the reply. So far I have figured out that the original file was actually a .123 extension that was renamed before being sent to us. Going to bring smart suite from home and try to export it as either a .wk4 or .xls. Although I have been told that exporting as an .xls can be a bit messy. I will report the results.

May 28th, 2002, 08:35 PM	#2
Jack in the UK Join Date: Feb 2002 Posts: 3,063	I would suggest if version 123 Year 97 or above, save as Xls.. and open then.. Or save each sheet ir correct sheet as CSV and import into excel and re build.. These ideas should work OK long time sine I used 123 suite 97. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 28th, 2002, 08:35 PM	#3
Jack in the UK Join Date: Feb 2002 Posts: 3,063	I would suggest if version 123 Year 97 or above, save as Xls.. and open then.. Or save each sheet ir correct sheet as CSV and import into excel and re build.. These ideas should work OK long time sine I used 123 suite 97. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

May 28th, 2002, 04:40 PM	#1
Wirlybird Join Date: May 2002 Posts: 5	Using Excel in Office 2000, I am trying to open a Lotus 123 file (.wk1 is the extention). I select *.wk? in the "file type" window and select the file I want to open. I then get the error "cannot open Lotus 123 file. Thanks for any thoughts. [ This Message was edited by: Wirlybird on 2002-05-28 13:23 ]

May 28th, 2002, 08:46 PM	#4
Wirlybird Join Date: May 2002 Posts: 5	Thanks for the reply. So far I have figured out that the original file was actually a .123 extension that was renamed before being sent to us. Going to bring smart suite from home and try to export it as either a .wk4 or .xls. Although I have been told that exporting as an .xls can be a bit messy. I will report the results.