XL: Shift Down And Copy Command Pastes Incorrect References

Last reviewed: March 27, 1997
Article ID: Q121642
5.00 5.00c 7.00 7.00a WINDOWS kbother

The information in this article applies to:

- Microsoft Excel for Windows 95, versions 7.0, 7.0a - Microsoft Excel for Windows, version 5.0, 5.0c

SYMPTOMS

When you are using a workbook that contains multiple sheets, and you use the Shift Down And Copy command on the shortcut menu (to access this menu click the right mouse button), links created in the inserted rows are not updated correctly in the third and subsequent sheets.

WORKAROUND

To work around this problem, follow the steps in the sample procedure below (you may need to adjust these steps slightly to suit your specific situation):

  1. Open a workbook that contains four worksheets.

  2. In cell A1 in Sheet2, type "=sheet1!A1" (without the quotation marks).

  3. In cell A1 on Sheet3, type "=sheet2!A1" (without the quotation marks).

  4. In cell A1 on Sheet4, type "=sheet3!A1" (without the quotation marks), and select all four sheet tabs.

  5. Select row 2 on Sheet1.

  6. From the Insert menu, choose Rows (assuming there is data on row 2), this will insert a new row before the old row.

  7. On Sheet1, select Row 1.

  8. Use the right mouse button to drag the selection down one Row.

  9. From the shortcut menu, choose Copy.

This should copy the data and formulas in row one from all sheets and place updated references and data in the new row 2 on all of the sheets in the workbook.


KBCategory: kbother
KBSubcategory: xlwin

Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a
Keywords : xlwin kbother
Version : 5.00 5.00c 7.00 7.00a
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.