Discussion Locked

Converting 123 97 Edition of Lotus workb

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can I convert a 123 Workbook with aht .123 extension and Macros into Excel 2000.

5 replies

by mikedale

I am not sure what file standard a lotus .123 file is, lotus spreadsheets are usually .wks or .wk?

I sugest you use Lotus to convert the spreadsheet file to a .wks format (go file save as, then select the appropiate file type)

Then in Excel, go File open, in the Open dialog box find the boc labeled 'Files of Type'

Select 'Lotus 123 files' from the list, point the open dialog box to the folder your file is stored in. Open your Lotus file with Excel.

Excel has convert filters. your Lotus spreadsheet will be converted to a fully working Excel spreadsheet.

Note: your Lotus macros will not be converted to Excel Macros, but Excel will support and run your Lotus Macros

Hope this helps

Mike Dale

by dmiles

My suggestion is to Ref:Related KB article Q214237 and For more information about data-definition queries,choose Microsoft Excel Help from the Help menu, type How can I save a file in a different format
Related KB article Q212174

This discussion is closed to new replies.