Works: Pasting Data from Database into Spreadsheet Clears Some Cells

When you copy data from the last (rightmost) field in List view of a Works Database and paste the data into a Spreadsheet, cells to the right of the destination cells are overwritten with blanks. For example, assume your Database has 5 fields and your Spreadsheet has 10 columns. If you select 5 fields from the Database and paste them into the first column of the Spreadsheet, columns 6 through 10 will be overwritten.

This behavior only occurs if you have included the last field in the database in your selection. To prevent this behavior from occurring, add a column to the end of your database.

To add a column to your database do the following:

1. Open your Database and on the View menu, click List.
2. Click the last (rightmost) field.
3. On the Record menu, point to Insert Field and click After.
4. On the Insert Field dialog box, click Add and then click Done.
5. On the Format menu, click Field Width.
6. Set the field width to zero and click OK.

You will not see the field you added; if you need to select it again, use Go To on the Edit menu to select it and set the width to a positive value.

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