Microsoft KB Archive/213962

= XL2000: Copying Sheets Between Workbooks Can Create Unexpected Links =

Article ID: 213962

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:
 * 1) Switch to the target workbook (the workbook that contains the link) and save it.
 * 2) On the Edit menu, click Links.
 * 3) 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



MORE INFORMATION
Any time a sheet (such as a worksheet, a dialog sheet, or a macro sheet) that contains a named range is copied to another workbook, Excel adds the referenced named range to the Define Name list as a global name that defines the link to the original workbook. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

214301 XL2000: Unexpected Results When Pasting Linked Text Box

213443 XL2000: Visual Basic Macro to Break Chart Links

213385 XL2000: How to Programmatically Delete Defined Names with Links

Additional query words: added Q138619 per paulpe XL2000

Keywords: kbprb KB213962

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.