XL97: Pasting Entire Column Is Slower than in Earlier Versions

 Last reviewed: February 18, 1998
Article ID: Q156869
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you copy and then paste an entire column in a worksheet, the paste operation may take up to four times as long to complete as it does in earlier versions of Microsoft Excel.

CAUSE

Worksheets in earlier versions of Microsoft Excel can contain up to 16384 rows of information; worksheets in Microsoft Excel 97 can contain up to 65536 rows, or four times the number rows that earlier versions handle.

MORE INFORMATION

The amount of time required to paste copied cells is roughly proportional to the number of cells you copy. For example, if you copy an entire column of cells in Microsoft Excel 97, the time required to paste the 65536 cells is roughly four times the time required to perform the same operation in an earlier version of Microsoft Excel. This is true because a column of cells in an earlier version contains only 16384 cells.

Additional query words: XL97 8.0 pasted 16,384 65,536 limit
specification max maximum slow 4 times
Keywords : xlformula xlui kbualink97
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.