Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Open Lotus 1-2-3 files in Excel 2007Helpful Member!(2) 

fentocy (TechnicalUser) (OP)
27 Oct 09 12:19
Can anyone tell me how to open a Lotus 1-2-3 file in Excel 2007?  Previous versions of Office allowed this file type to be imported or opened.
xlhelp (Instructor)
27 Oct 09 14:06
Office Button; Excel Options; Advanced; Lotus Compatibility Settings; select Transition Formula Entry to convert the file to Excel.

A man has only two choices: He can be right or he can be happy.

fentocy (TechnicalUser) (OP)
27 Oct 09 15:58
That didn't work for me.  It applies the Advanced settings to the workbook or worksheet that is currently open and then the setting defaults back to unchecked.  When I open the wk4 file in Excel, it is unreadable.  It doesn't convert to Excel.
xlhelp (Instructor)
27 Oct 09 16:34
I was under the impression that Excel Options, once selected need to be deselected. Are you sure there is something else funny not going on?

A man has only two choices: He can be right or he can be happy.

fentocy (TechnicalUser) (OP)
27 Oct 09 17:01
Those two particular settings in Excel Options, Advanced, are listed with the specific document chosen in the drop-down box just above the two checkboxes.
Helpful Member!(2)  cmeagan656 (TechnicalUser)
27 Oct 09 17:05
I know this isn't what you want to hear but Lotus 1-2-3 files are no longer supported as of Excel 2007.

From Microsoft Excel 2007 Help:


File formats that are not supported in Excel 2007
The following file formats are no longer supported in Office Excel 2007. You cannot open or save files in these file formats.

WK1, FMT, WK2, WK3, FM3, WK4     .wk1, .wk2, .wk3, .wk4, .wks    Lotus 1-2-3 file formats (all versions)

Hope this helps.

Please help us help you.  Read Tek-Tips posting polices before posting.

xlhelp (Instructor)
27 Oct 09 22:23
Yup, I was wrong. Sorry about mis-information.

A man has only two choices: He can be right or he can be happy.

cmeagan656 (TechnicalUser)
27 Oct 09 23:08
If the files are really important then you could buy a copy of WordPerfect Office X4 Home/Student edition (about $125 USD), open the files in Quatro Pro (Lotus 1-2-3's successor), and save them as Excel 97-2003 files.  You could then open those files using Excel 2007.

Other alternatives (free) might be to try either Open Office or Google Docs.  I don't use either so I don't know if they are capable of converting Lotus 1-2-3 files to something that is Excel 2007 compatible.

Hope this helps.

Please help us help you.  Read Tek-Tips posting polices before posting.

JockMullin (MIS)
28 Oct 09 9:42
OpenOffice does indeed support Lotus 1-2-3 .wk1 ... .wks file formats as per cmeagan656's suggestion, and can write MS Office compatible formats.

However, fancy features and especially macros may or may not be compatible in my experience.

I don't have any 1-2-3 files to test, but they are in the "files of type" list in OO Calc module.

dbMark (Programmer)
17 Dec 09 10:51
This ia a data import workaround for a .WKS compatible spreadsheet. (Note that this was tested with data only, no formulas.)

Excel 2007:  (have a new or empty workbook open)
Menu: Data
  From Other Sources
    From xml Data Import
      Browse & select file (change Files of type to "All files")
      OK (Existing worksheet)

I do not know whether this works with other obsoleted file types.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close