XL97: Unexpected Results Paste Linking Noncontiguous Range (159958)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q159958 SYMPTOMS
When you use the Paste Link command to link to a noncontiguous range, the
link that is created may refer to cells that are not in the range that you
copied.
WORKAROUND
To work around this problem, do not copy a noncontiguous range of cells if
you want to create a link to that range by clicking Paste Link. Instead,
copy each contiguous range of cells in the noncontiguous range, and paste a
link to each range separately. For example, given the following data:
A1: a
A2: b
A3:
A4: c
A5: d
to paste a link to cells A1:A2,A4:A5 to B1:B4, do the following:
- Select cells A1:A2.
- On the Edit menu, click Copy.
- Select cell B1.
- Click Paste Special on the Edit menu, and then click Paste Link.
- Select cells A4:A5.
- On the Edit menu, click Copy.
- Select cell B3.
- Click Paste Special on the Edit menu, and click Paste Link.
The link results are as follows:
A1: a B1: a
A2: b B2: b
A3: B3: c
A4: c B4: d
A5: d B5:
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbbug KB159958 |
---|
|