Microsoft KB Archive/239351

= Works 2000: Cannot Copy an Entire Database Column to a Spreadsheet =

Article ID: 239351

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000

-



This article was previously published under Q239351



SYMPTOMS
When you copy a column of data in a Microsoft Works 2000 Database by clicking the field name cell (the whole column is automatically selected), and then clicking Copy on the Edit menu, and you then attempt to paste the column into a Works 2000 Spreadsheet column or cell, the following error message may appear:

The Clipboard contents cannot be pasted here.

Make sure the destination area is as large as the information you want to paste, or select only a single cell where you want to paste.



CAUSE
This behavior can occur because the Works 2000 Database can support 32,000 rows and the Works 2000 Spreadsheet can only support 16,384 rows. When you click the field name cell on the Database, you automatically select every row in the Database, even if there is no data in the row.



WORKAROUND
To work around this issue, select and copy only the cells in the Database that you want to paste into a Works 2000 Speadsheet. To illustrate this, follow these steps:  Start the Works 2000 Database, and then create a blank database. On the Create Database dialog box, in the Field name box, type DATA . Click Add, and then click Done.  Create the following database in the DATA field:   1: Apple 2: Pear 3: Peach 4: Orange 5: Banana  Select cells 1 through 5 in the DATA field. On the Edit menu, click Copy.</li> Start the Works 2000 Spreadsheet.</li> Select cell A:1.</li> On the Edit menu, click Paste. The Database is successfully copied.</li></ol>

<div class="status_section">

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

Keywords: kbaddin kbbug kbpending KB239351

-

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

© Microsoft Corporation. All rights reserved.