XL2000: Unexpected Results When Pasting Linked Text Box (214301)

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.

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.