Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an old lotus file on a disk. I want to pull it up as an excel file
with the formaulas intact. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Open an excel file but it does not display | Excel Discussion (Misc queries) | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
How save a lotus 2.2 file in excel and to open it in excel and pe. | New Users to Excel | |||
unable to open Excel file by double clicks | Excel Discussion (Misc queries) |