Microsoft KB Archive/65650

Works: Using Edit Copy Versus Edit Move in a Spreadsheet

PSS ID Number: Q65650 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

If you use the Edit Move command in a Microsoft Works spreadsheet to move selected cells into a range that is referred to by a formula, an ERR message will appear in the formula cell.

For example, with the formula

=SUM(A1:A10)

if you include cells A1 and A10 when you insert new data with the Edit Move command, an ERR message will result in the formula cell.

The Edit Move command was intended to be used in moving cells or a range of cells to an area of the spreadsheet that does not contain a formula.

To move information to an area that contains a formula, use the Edit Copy command instead of the Edit Move command.

Reference (s):

“Microsoft Works Reference.” Version 2.00. Page 128, “To Move a Cell or Range,” and Page 110, “To Copy a Cell or Range.”

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.