Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105818

From BetaArchive Wiki
Knowledge Base

Too Many Cells Pasted When You Copy Data to Lotus 1-2-3

Article ID: 105818

Article Last Modified on 8/15/2005


  • Microsoft Excel 95a
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 4.0a
  • Microsoft Excel 4.0 Standard Edition
  • Microsoft Excel 3.0 Standard Edition
  • Microsoft Excel 2.1 Standard Edition

This article was previously published under Q105818


When you copy cells from Microsoft Excel and paste them into Lotus 1-2-3 Release 1.0 or 1.1 for Windows, you may notice that the cells appear in the wrong location. Also, the contents of other cells in your 1-2-3 worksheet may be cleared.

This error does not occur in Lotus 1-2-3 for Windows, version 4.0.

This error may occur in Quattro Pro for Windows, versions 1.0 and 5.0.


To work around this problem, do either of the following:

  • When you copy data from Microsoft Excel to Lotus 1-2-3 for Windows, include cell A1 in the copy operation. This will cause the .WK1 clipboard data matrix to be identical to the actual range, and you will be able to copy and paste successfully.


  • When you copy data from Microsoft Excel and paste it in Lotus 1-2-3 for Windows, paste the data into an unused section of the 1-2-3 worksheet or in a new 1-2-3 worksheet. Then, copy the information from this location and paste it to the desired location on the worksheet.


This error occurs because of the way Microsoft Excel creates .WK1 (Lotus 1-2-3 format) clipboard data. When the .WK1 clipboard data is created, Microsoft Excel creates a matrix that ranges from cell A1 to the lower-right cell of the copied range instead of creating a matrix with the same size as the copied range.

For example, if you copy the range H8:J10, a matrix three cells wide by three cells across should be pasted to the .WK1 clipboard. However, a matrix of 10 cells wide by 10 cells across (A1:J10) is created instead.

When this matrix is pasted into Lotus 1-2-3, the upper-left corner of the matrix is pasted into the active cell, and the rest of the matrix "lands" in cells below and to the right of the active cell.

This error does not occur in Lotus 1-2-3 Release 4.0 for Windows, because of the way in which .WK1 clipboard data from Microsoft Excel is received by 1-2-3.

Additional query words: 4.00a XL

Keywords: KB105818