XL2000: Copying Sheets Between Workbooks Can Create Unexpected Links (213962)
The information in this article applies to:
This article was previously published under Q213962 SYMPTOMS
When you copy a sheet to a target workbook, you may establish a link to
the source workbook that remains even after the copied sheet is
deleted from the target workbook.
Examples
If you copy a dialog sheet to another workbook, and the dialog sheet
contains any of the following
- check box
- option button
- list box
- combo box
- scroll bar
- spin box
and the Input Range or Cell Link box on the Control tab of the Object dialog box contains a reference, Excel creates a link to the source workbook. Additionally, if the Input Range or Cell Link box references a named range, the named range is added to the target workbook's Define Name list.
If you copy a worksheet or macro sheet that contains a formula that
references another worksheet in the source workbook, Excel creates a link to the source workbook. Additionally, if the formula that references another worksheet in the source workbook contains a named range, Excel adds the named range to the target workbook's Define Name list.
WORKAROUND
To delete the unwanted link, follow these steps:
- Switch to the target workbook (the workbook that contains the link)
and save it.
- On the Edit menu, click Links.
- In the Source File list, click the link, and then click Change Source. Locate the target workbook in the Change Links dialog box and click OK.
For additional information about an alternate workaround, click the article number below
to view the article in the Microsoft Knowledge Base:
188449 XL: Delete Links Wizard Available
| Modification Type: | Major | Last Reviewed: | 10/8/2003 |
|---|
| Keywords: | kbprb KB213962 |
|---|
|