ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting a Lotus 123 file to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/80759-converting-lotus-123-file-excel.html)

Greenback

Converting a Lotus 123 file to Excel
 
I have been sent a large Lotus 123 file ( version 9 of Lotus 123 ) and I
would like to convert to Excel 2002 xp. How would I do this, bearing in mind
that the Lotus 123 file has a number of formulas and links from cells in one
worksheet in Lotus to another worksheet in the same workbook.

Francois via OfficeKB.com

Converting a Lotus 123 file to Excel
 
Greenback wrote:
I have been sent a large Lotus 123 file ( version 9 of Lotus 123 ) and I
would like to convert to Excel 2002 xp. How would I do this, bearing in mind
that the Lotus 123 file has a number of formulas and links from cells in one
worksheet in Lotus to another worksheet in the same workbook.


Open the file in 123,
File save as pick excel .XLS

When it's 'translated' open it in excel Hopefully most of
it will be OK


I have translated several LARGE COMPLICATED files and didn't have much
trouble redoing the few bits that didn't translate right


Good luck

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1

Greenback

Converting a Lotus 123 file to Excel
 
Cheers Francois....I had to convert the original .123 file to a .wk4 file and
then open that in Excel and then save as an excel workbook. I have a few
errors, but as you said, these errors can easily be recitified.

Thanks again

"Francois via OfficeKB.com" wrote:

Greenback wrote:
I have been sent a large Lotus 123 file ( version 9 of Lotus 123 ) and I
would like to convert to Excel 2002 xp. How would I do this, bearing in mind
that the Lotus 123 file has a number of formulas and links from cells in one
worksheet in Lotus to another worksheet in the same workbook.


Open the file in 123,
File save as pick excel .XLS

When it's 'translated' open it in excel Hopefully most of
it will be OK


I have translated several LARGE COMPLICATED files and didn't have much
trouble redoing the few bits that didn't translate right


Good luck

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1



All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com