Microsoft KB Archive/239167

= Works 2000: Spreadsheet Takes a Long Time to Copy to Excel =

Article ID: 239167

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000

-



This article was previously published under Q239167



SYMPTOMS
When you Copy a large Works Spreadsheet and then Paste the contents into an Excel Worksheet, it may take a long time to complete the operation.

A Pentium 90 computer may take as much as 3 minutes, faster machines may take 5 to 10 seconds.

When you Paste the same spreadsheet into another Works Spreadsheet, it takes very little time to complete the ooperation.



CAUSE
This problem occurs if you click Select All on the Edit menu to select the Works Spreadsheet data, before you Copy the data. The Select All command selects all the cells in the Spreadsheet, including the empty cells.



RESOLUTION
To resolve this problem, use the mouse to select only the cells that contain data before you click Copy on the Edit menu.

TIP: A fast way to do this is to click the left uppermost cell of the spreadsheet, then press SHIFT while you click the right lowermost cell of the spreadsheet.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbprb KB239167

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.