A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

lotus 2.4 spreadsheet conversion



 
 
Thread Tools Display Modes
  #1  
Old March 20th, 2009, 11:54 PM posted to microsoft.public.excel.misc
longhorntex
external usenet poster
 
Posts: 3
Default lotus 2.4 spreadsheet conversion

I'm having trouble converter many old lotus 2.4 spreadsheets to excel. Any
suggestions ?
  #2  
Old March 21st, 2009, 02:10 AM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default lotus 2.4 spreadsheet conversion

hi
lotus 2.4
i think (if memory serves me correct) that is a WK4 format.
WK4 was supported by excel intill 2007. so i suspect that you have 2007 AND
microsoft has quit supporting lotus altogeather since 2007.
work around.....find someone who still has excel 03 or earlier. open and
save as a .xls file. 2007 can open those. if you know someone who has lotus
2k, open and save as a .xls. (lotus 2k will save a file in excel format
faster that excel can save a excel file in excel format. impressive.)
you may wish to do a google on lotus files to excel files converter. i am
sure there are a number of packages out there. some may want money so that
would depend on your degree of desperation.
wish i could help more but since microsoft, in it's monolithic glory, has
decided not to support lotus anymore, individuals like yourself have been
left high and dry.

Good luck
regards
FSt1


"longhorntex" wrote:

I'm having trouble converter many old lotus 2.4 spreadsheets to excel. Any
suggestions ?

  #3  
Old March 21st, 2009, 03:54 AM posted to microsoft.public.excel.misc
Sheeloo[_4_]
external usenet poster
 
Posts: 204
Default lotus 2.4 spreadsheet conversion

"longhorntex"

I can try to convert it for you...
Either send it to me by mail or upload to a website and paste the link here.

"FSt1" wrote:

hi
lotus 2.4
i think (if memory serves me correct) that is a WK4 format.
WK4 was supported by excel intill 2007. so i suspect that you have 2007 AND
microsoft has quit supporting lotus altogeather since 2007.
work around.....find someone who still has excel 03 or earlier. open and
save as a .xls file. 2007 can open those. if you know someone who has lotus
2k, open and save as a .xls. (lotus 2k will save a file in excel format
faster that excel can save a excel file in excel format. impressive.)
you may wish to do a google on lotus files to excel files converter. i am
sure there are a number of packages out there. some may want money so that
would depend on your degree of desperation.
wish i could help more but since microsoft, in it's monolithic glory, has
decided not to support lotus anymore, individuals like yourself have been
left high and dry.

Good luck
regards
FSt1


"longhorntex" wrote:

I'm having trouble converter many old lotus 2.4 spreadsheets to excel. Any
suggestions ?

  #4  
Old March 22nd, 2009, 03:07 PM posted to microsoft.public.excel.misc
longhorntex
external usenet poster
 
Posts: 3
Default lotus 2.4 spreadsheet conversion

lotus 2.4 - excel 2003 - google

Thanks !

I, with your help, have succeeded in solving that original registry problem.

But I now have succeeding questions, to convert the excel 2003 spreadsheets
to google spreadsheets.

Ultimately, I need to convert some 230 Lotus 2.4 spreadsheets to google.

The first issue is that the Lotus 2.4 spreadsheets, when opened in excel
2003 (which can be converted to google), correctly displays in the window at
the top of the excel 2003 spreadsheet, the contents of the cell where the
cursor happens to be. The critical case is when the cell contains a named
range/cell from a linked spreadsheet. Although in the top window the name in
the linked cell is correct, in the body of the spreadsheet, the corresponding
cell contains #VALUE! , instead of what is correctly displayed in the top
window.


A later question would be: is there an automated way to convert all 230
spreadsheets at once, in bulk as it were, or must each spreadsheet be
converted individually, by hand ?

If you'd care to email me, my address is .

Thanks again !





"Sheeloo" wrote:

"longhorntex"

I can try to convert it for you...
Either send it to me by mail or upload to a website and paste the link here.

"FSt1" wrote:

hi
lotus 2.4
i think (if memory serves me correct) that is a WK4 format.
WK4 was supported by excel intill 2007. so i suspect that you have 2007 AND
microsoft has quit supporting lotus altogeather since 2007.
work around.....find someone who still has excel 03 or earlier. open and
save as a .xls file. 2007 can open those. if you know someone who has lotus
2k, open and save as a .xls. (lotus 2k will save a file in excel format
faster that excel can save a excel file in excel format. impressive.)
you may wish to do a google on lotus files to excel files converter. i am
sure there are a number of packages out there. some may want money so that
would depend on your degree of desperation.
wish i could help more but since microsoft, in it's monolithic glory, has
decided not to support lotus anymore, individuals like yourself have been
left high and dry.

Good luck
regards
FSt1


"longhorntex" wrote:

I'm having trouble converter many old lotus 2.4 spreadsheets to excel. Any
suggestions ?

  #5  
Old April 12th, 2009, 10:36 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 1
Default lotus 2.4 spreadsheet conversion

On Mar 20, 11:54*pm, Sheeloo just
remove all As... wrote:
"longhorntex"

I can try to convert it for you...
Either send it to me by mail or upload to a website and paste the link here.

"FSt1" wrote:
hi
lotus 2.4
i think (if memory serves me correct) that is a WK4 format.
WK4 was supported by excel intill 2007. so i suspect that you have 2007 AND
microsoft has quit supporting lotus altogeather since 2007.
work around.....find someone who still has excel 03 or earlier. open and
save as a .xls file. 2007 can open those. if you know someone who has lotus
2k, open and save as a .xls. (lotus 2k will save a file in excel format
faster that excel can save a excel file in excel format. impressive.)
you may wish to do a google on lotus files to excel files converter. i am
sure there are a number of packages out there. some may want money so that
would depend on your degree of desperation.
wish i could help more but since microsoft, in it's monolithic glory, has
decided not to support lotus anymore, individuals like yourself have been
left high and dry.


Good luck
regards
FSt1


"longhorntex" wrote:


I'm having trouble converter many old lotus 2.4 spreadsheets *to excel. *Any
suggestions ?




I have solved the registry problem, and been advised to write a
conversion program in Visual Basic. But that appears a formidable
task.

The first issue is that the Lotus 2.4 spreadsheets, when opened in
excel 2003 (which can be converted to google), correctly display in
the window at the top of the excel 2003 spreadsheet, the contents of
the cell where the cursor happens to be. The critical case is when the
cell contains a named range/cell from a linked spreadsheet. Although
in the top window the name in the linked cell is correct, in the body
of the spreadsheet, the corresponding cell contains #VALUE! , instead
of what is correctly displayed in the top window.
Clearly, a threshold issue is the ".wk1" extension in the link
address, which must ultimately be converted to ".xls" .

I've also been advised to consider the excel fn "indirect" . Again,
I haven't a clue.

A later question would be: is there an automated way to convert all
230 spreadsheets at once, in bulk as it were, or must each spreadsheet
be converted individually, by hand ?

Please respond by email to me : .
  #6  
Old April 12th, 2009, 10:50 PM posted to microsoft.public.excel.misc
longhorntex
external usenet poster
 
Posts: 3
Default lotus 2.4 spreadsheet conversion



"FSt1" wrote:

hi
lotus 2.4
i think (if memory serves me correct) that is a WK4 format.
WK4 was supported by excel intill 2007. so i suspect that you have 2007 AND
microsoft has quit supporting lotus altogeather since 2007.
work around.....find someone who still has excel 03 or earlier. open and
save as a .xls file. 2007 can open those. if you know someone who has lotus
2k, open and save as a .xls. (lotus 2k will save a file in excel format
faster that excel can save a excel file in excel format. impressive.)
you may wish to do a google on lotus files to excel files converter. i am
sure there are a number of packages out there. some may want money so that
would depend on your degree of desperation.
wish i could help more but since microsoft, in it's monolithic glory, has
decided not to support lotus anymore, individuals like yourself have been
left high and dry.

Good luck
regards
FSt1


"longhorntex" wrote:

I'm having trouble converter many old lotus 2.4 spreadsheets to excel. Any
suggestions ?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:28 PM.


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