Microsoft KB Archive/20404

Mac Works: Move Function Returns “Offsheet” Error Message

PSS ID Number: Q20404 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Works for the Macintosh, versions 1.x, 2.x, 3.x and 4.0 == 

= SUMMARY =

Using the Move command in Microsoft Works to move a value to a cell that is referenced by a formula may return “Offsheet” for the cell reference.

= WORKAROUND =

There are two possible workarounds:

Option 1
Instead of using the Move command to move a value to a cell that is referenced by a formula, use the Cut and Paste commands. To use Cut and Past to move a value, complete the following steps:


 * 1) Highlight the cell containing the value to be moved
 * 2) Choose Cut from the Edit menu.
 * 3) Highlight the cell where you want the value moved to.
 * 4) Choose Paste from the edit menu

NOTE: this option works only if the destination cells are empty.

To remove cells that are referenced in a formula and move other cells up, do the following:


 * 1) Highlight the cells to be removed and choose CLEAR from the Edit menu.
 * 2) Highlight the cells to be moved and choose CUT from the Edit menu.
 * 3) Click on the top left cell of the destination area and choose PASTE from the Edit menu.

Option 2
Before using the Move command to move a value to a cell that is referenced by a formula, always clear the contents of the destination cell first, and then move the new value to that cell.

= MORE INFORMATION =

To illustrate this problem, do the following:

  In cell A1 type 1.   In cell A2 type =A1+1.   In cell A3 type 2.   Select cell A3.   From the Edit menu, choose Move.   In the Enter Destination Cell For Move box, type A1. Cell A2 will display “N/A” and the formula bar will read “=Offsheet+1”. </li></ol>

The “Offsheet” error is returned because rows 1 and 2 have been moved to rows that do not exist on the spreadsheet.

= Additional query words: 1.00 1.10 2.00 3.00 4.00 offsheet mwksss =

Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.