Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cal
 
Posts: n/a
Default trying to open a lotus file in excel, it won't work

I have an old lotus file on a disk. I want to pull it up as an excel file
with the formaulas intact.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default trying to open a lotus file in excel, it won't work

"cal" wrote...
I have an old lotus file on a disk. I want to pull it up as an excel file
with the formaulas intact.


In what way does it not work?

* Can't open the file? Excel won't open files in .123 format. Excel can open
..WK4 and prior formats, but Microsoft had already secured so much market
share by the time Lotus Development Corp came out with a true 32-bit version
of 123 (97 Edition, which provided the then new .123 file format) that
Microsoft just didn't bother to provide file filters for it. If this is your
situation, you're only options are using 32-bit versions of 123, Quattro Pro
version 10 or later or DataViz's ConversionPlus package to open the .123
files and convert them into .WK4 files (IMO, less is lost converting .123
files into .WK4 format than into .XLS format, but there are exceptions to
this rule-of-thumb).

* File opens, but some formulas are replaced by values? Some common issues.

** Excel isn't a true 3D spreadsheet, so Excel replaces any & all 123
formulas involving 3D ranges with their values (which are stored along with
the formulas in .123 and .WK? files). There's NO solution for this other
than opening the .WK? file in 123 or QuattroPro, converting the formula to a
text string by inserting an apostrophe at the beginning, saving the file,
then figuring some work-around when you open the file in Excel. There are
common work-arounds, but you have to give some idea what the original
formulas look like.

** 123 from Release 3.0 allows its database functions, e.g., @DSUM, to use
criteria *expressions* rather than criteria ranges. Excel, on the other
hand, is mired in 123 Release 2.x functionality and requires criteria ranges
all the time. Again, there are fixes, but you have to provide details.

* You're esperiencing some other problem? If you don't provide details,
you're not going to get anything more than general responses like this.


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
Saved *.csv file gives SYLK file type warning upon Excel 2003 open Tom Excel Discussion (Misc queries) 5 March 19th 08 03:15 PM
Open an excel file but it does not display Fred Zack Excel Discussion (Misc queries) 3 December 21st 05 06:45 PM
How do I open a Quattro Pro 7.0 file in Excel 2003 cpatrick83 Excel Discussion (Misc queries) 0 August 22nd 05 09:41 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
unable to open Excel file by double clicks Renyan Excel Discussion (Misc queries) 2 January 16th 05 01:07 AM


All times are GMT +1. The time now is 01:45 AM.

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"