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
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.
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.
6. From the Insert menu, choose Rows (assuming there is data on row
2), this will insert a new row before the old row.
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
Version : 5.00 5.00c 7.00 7.00a
Platform : WINDOWSLast Reviewed: March 30, 1997