Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greenback
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Francois via OfficeKB.com
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
Greenback
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open a Lotus 1-2-3 file using Excel 2003 Teri Excel Discussion (Misc queries) 3 April 5th 07 07:44 AM
How do I unlock FILE access? rcmodelr Excel Discussion (Misc queries) 7 November 12th 05 09:55 PM
File size too big after converting Lotus 1-2-3 to Excel Learner Excel Discussion (Misc queries) 3 June 10th 05 08:27 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
How save a lotus 2.2 file in excel and to open it in excel and pe. bird New Users to Excel 0 February 26th 05 01:57 AM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"