Unexpected Results When Pasting Linked Text Box (106718)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q106718 SYMPTOMS
In the versions of Microsoft Excel listed above, 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 do this manually do the
following (in this example, the text box is linked to Sheet1!$A$1):
- Copy the text box.
- Switch to the sheet (for example, Sheet2) where the text box will be
pasted.
- Paste the text box in the desired location.
- While the text box is still selected, edit the formula in the formula
bar so that it reads "=Sheet1!$A$1" (without the quotation marks).
- Press ENTER.
The text box is now linked to the cell to which it was originally linked.
REFERENCES
"User's Guide 1," version 5.0, page 231
Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
---|
Keywords: | kbprb KB106718 |
---|
|