|
Lotus 123 spreadsheet will not convert to Excel 97
Sometimes a Lotus 123 spreadsheet simply will not convert to Excel. This could be caused by the
presence of Windows Metafiles (*.wmf). Open the spreadsheet in Lotus 123 and check for any logos
that are saved as "metafiles". Cut the logos to the clipboard in Lotus 123, save and close;
then open the file in Excel to convert the spreadsheet and paste the logos back in.
Lotus 123 spreadsheet takes too long to convert to Excel 97
Occasionally, a Lotus 123 spreadsheet may take 10 or more minutes
to convert to Excel, and if the spreadsheet does convert, it appears to be much larger in size than it
should be. We are not certain of why this corruption happens, but the solution is easy. Open
up the spreadsheet in Lotus 123. Find the last column of data in the spreadsheet. Select the first empty column
(make sure you select the column heading so the entire column is selected) and press SHIFT + END + RIGHT arrow.
This should take you to column IV. Select EDIT, CLEAR, BOTH to delete everything to the right of the your
data. Then find the last row of data in the spreadsheet. Select the first empty row (make sure you select the row
heading so the entire row is selected) and press SHIFT + END+ DOWN arrow. This should take you to row
8,192. Again, select EDIT, CLEAR, BOTH to delete everything below your data. Save and close. Now try and
convert your spreadsheet by opening it in Excel.
Is there a quick method to convert large numbers of Lotus 123 spreadsheets
to Excel 97?
You can use the File Conversion Wizard to convert large numbers of Lotus 123 spreadsheets all at
once. This tool is located under Tools, Wizard, File Conversion. Follow the three steps and upon completion
of the conversion, a report is generated in a new workbook that outlines what files were converted. We find the File
Conversion Utility to be very good.
#REF Errors show in the converted Excel Worksheet
A Lotus 123 spreadsheet with a linking formula the makes a reference to an external workbook will
produce a #REF error message. To resolve this issue in Excel, select Edit, Link and Change Source.
Locate the Excel file and click OK.
@COORD function fails to convert
The @COORD function creates a cell reference from values you specify for the worksheet, column and
a row, by adding a @@ in front of the function, it will return the value of the cell. This function will fail to convert
to Lotus 123. The solution is to replace the @COORD function with the =HLOOKUP function in Excel.
@DSUM function fails to convert
The @DSUM function will not convert from Lotus 123 to Excel. A #NAME? error message appears in the cell in
the converted spreadsheet. The solution is to rebuild the =DSUM in Excel.
@PMTC function fails to convert
The @PMTC function in Lotus 123 calculates the Payment using Canadian conventions. There is no Excel 97
equivalent of this function.
Some Nested @IF Statements fail to convert
A Lotus 123 spreadsheet with a nested @IF statement that has more than 7 levels will not convert to
Excel. The formula will have to be rebuilt using =HLOOKUP, =VLOOKUP or some other
Excel function.
Some @NPV functions fail to convert
The @NPV function will convert to Excel; however, if you define the type as 1 (payments assume to
begin at the beginning of the period), the function will fail to convert. A possible solution is to use the
=XNPV(rate,value,dates) function for payments that start at the beginning of the period.
|
