I am trying to open a Lotus spreadsheet (wk4) using Excel 2007 and I can not. I can open it using 2003 but have upgraded users to excel 2007.
Is there a filter I can load so that I do not have to open the hundreds of lotus123 spreadsheets using excel 2003 and save them as .xls so my users can open them in excel 2007>
Please help
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Not accepted:).
My problem is I can not open the lotus 123 spreadsheet in excel 2007 in order to save it. I can only open the lotus 123 in excel 2003 then save as .xls but I have already installed 2007 on the users computers.
So how I can I get excel 2007 to open a lotus 123 spreaheet so I can save it properly??
thanks
These are only the file formats that are supported by Excel 2007.
Format Extension
Excel Workbook .xlsx
Excel Workbook (code) .xlsm
Excel Binary Workbook .xlsb
Template .xltx
Template (code) .xltxm
Excel 97- Excel 2003 Workbook .xls
Excel 97- Excel 2003 Template .xlt
Microsoft Excel 5.0/95 Workbook .xls
XML Spreadsheet 2003 .xml
XML Data .xml
Excel Add-In .xlam
Excel 97-2003 Add-In .xla
I tried Free Open but it did not work. So I rolled the user back to 2003 Excel (Offcie XP). I then went to the Excel folder and tried opening an excel spreadsheet and NONE of the spreadsheets were named (wk4) as when I tried to open them in Excel 2007. They all had extensions of .xls including the ones that had extesions in excel 2007 as (wk4).
Why woudl this be????
Acutally you can continue to open the wk4 files, but you must re-enable the file exentsions in your office product. This KB article, http://support.microsoft.c
Business Accounts
Answer for Membership
by: ScanRPosted on 2007-10-10 at 11:03:40ID: 20050795
Try to check this:
Converting files
Saving in Microsoft Excel file format Excel stores the file format of any file you open. When you save a file, Excel uses the same format the file was in when you opened it. For example, if you open a Lotus 1-2-3 file with a .wk3 extension, Excel saves the file as a Lotus 1-2-3 file with a .wk3 extension. If you make changes to the file in Excel, you should save the file in an Excel file format to be sure all of your changes are saved. To do this, be sure to use the Save As command and select Microsoft Excel Workbook in the Save as type box.
Changing the file name extension When you save a workbook as a different type by changing the file format in the Save as type box, you do not have to change the file name, because Excel saves a copy of the workbook with a different file name extension. For example, a Lotus 1-2-3 Release 4.0 file has a file name extension of .wk4; Excel Workbook format uses the .xls file name extension.
Typing a new extension in the File name box, or renaming the file with a new extension in the folder window, is not sufficient to change the file type. You must also change the Save as type box to the file type you want.
Applying formatting from associated Lotus 1-2-3 files When you open a Lotus 1-2-3 worksheet or workbook in Excel, Excel applies the formatting in the associated .fmt, .fm3, or .all file. Make sure the associated file is stored in the same folder as the .wk? file. If you save a Lotus 1-2-3 file in Excel format, Excel saves the spreadsheet data and formatting in a single workbook file.