XL98: Pasting Entire Column Is Slower Than in Earlier Versions
Article ID: 181570
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q181570
SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, 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 98 Macintosh Edition can
contain up to 65536 rows, or four times the number of 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 98 Macintosh Edition, 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: XL98 pasted 16,384 65,536 limit specification max maximum slow 4 times
Keywords: kbualink97 kbprb KB181570