Microsoft KB Archive/214301

= XL2000: Unexpected Results When Pasting Linked Text Box =

Article ID: 214301

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214301





SYMPTOMS
In Microsoft Excel 2000, if you copy and paste a text box that has been linked to a cell in a worksheet, the link may not be updated properly, depending on where you paste the text box.



WORKAROUND
If a text box is pasted into another sheet, you cannot automatically maintain the link to the original sheet. To manually maintain the original link, follow these steps (in this example, the text box is linked to Sheet1!$A$1):  Copy the text box: Select it, and then click Copy on the Edit menu. Switch to the sheet (for example, Sheet2) where the text box will be pasted. Paste the text box in the location that you want by clicking Paste on the Edit menu. While the text box is still selected, edit the formula in the formula bar so that it reads as follows:

=Sheet1!$A$1

 Press ENTER. The text box is now linked to the cell to which it was originally linked.

<div class="moreinformation_section">

MORE INFORMATION
If you copy a text box from a worksheet or an Excel macro sheet (for example, Sheet1) that has been linked to a cell in the same sheet with the formula =$A$1 or =Sheet1!$A$1, you receive different results depending on where you paste the text box.

Worksheet or Excel Macro Sheet
The text box becomes linked to cell A1 on the sheet where you paste it. For example, if you paste the text box in Sheet2, the text box is linked to cell A1 in Sheet2.

Chart Sheet
The text box loses its link to cell A1, but the value displayed in the text box remains. For example, if cell A1 in Sheet1 contains the text "Sample," the text box still contains "Sample" when you paste it onto the chart.

Dialog Sheet
The text box attempts to link to cell A1 in the dialog sheet. Because there are no cells in a dialog sheet, the text box appears blank. In this case, use the workaround described in the "Workaround" section to restore the proper link.

Reference Includes Sheet Name
Text boxes remain linked to the correct cell as long as the reference to the cell also includes the sheet name. For example, if the link resembles the following

=Sheet1!$A$1

the text box links to that cell, no matter where you paste it.

Additional query words: XL2000

Keywords: kbprb KB214301

-

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

© Microsoft Corporation. All rights reserved.