Works 2000: Pasted Cells Contain Unexpected Values (250595)
The information in this article applies to:
- Microsoft Works 2000
- Microsoft Works Suite 2000
This article was previously published under Q250595 SYMPTOMS
When you paste cells from one spreadsheet into another in Microsoft Works 2000, you may experience the following symptoms:
- The Paste Special command on the Edit menu may be
unavailable.
- The cells into which you paste are blank, contain zeros, or
contain unexpected values.
CAUSE
This behavior can occur if the following conditions are true:
- The cells that you copy contain at least one formula or function.
- The copied formula or function refers to a cell or cells outside
of the copied range of cells.
- The cell or cells that are referred to by the copied formula or
function are located in the same spreadsheet as the copied range of
cells.
- You paste the copied range of cells into a range of cells in a
different spreadsheet.
RESOLUTION
To work around this issue:
- Open the spreadsheet from which you want to copy a cell or cells.
- Click and drag to select the cell or cells that you want to copy.
- On the Edit menu, click Copy.
- In the same spreadsheet, click and drag to select a blank cell or a
range of blank cells that match the number of rows and columns that you
copied in step 3.
- On the Edit menu, click Paste Special to paste the
cells as values only.
- On the Edit menu, click Copy.
- Open the spreadsheet into which you want to paste the copied values.
- Click and drag to select the cell or range of cells in which you want
to paste the values.
NOTE: The number of rows and columns that you select must match
the number of rows and columns of the cell or range of cells that you
copied.
- On the Edit menu, click Paste.
MORE INFORMATION
The functionality of the Copy and Paste commands in Works 2000 is
slightly different than in previous versions of Works. In previous
versions, you were able to copy the values (results) of formulas
in cells from one spreadsheet to another, but not the formulas.
In Works 2000, the Copy command copies the formula itself, not the
value. If you copy a cell that contains a formula that refers to at
least one cell that is not included in the range of copied cells,
the Paste command pastes the formula, and the value or result of
that pasted formula may be a blank cell or an unexpected value.
NOTE: Microsoft Works 6 does not copy the formula even if you
first paste the formula into the spreadsheet that you are working on.
| Modification Type: | Major | Last Reviewed: | 6/29/2004 |
|---|
| Keywords: | kbprb kbui KB250595 |
|---|
|