Microsoft KB Archive/159958

= XL97: Unexpected Results Paste Linking Noncontiguous Range =

Article ID: 159958

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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:
 * 1) Select cells A1:A2.
 * 2) On the Edit menu, click Copy.
 * 3) Select cell B1.
 * 4) Click Paste Special on the Edit menu, and then click Paste Link.
 * 5) Select cells A4:A5.
 * 6) On the Edit menu, click Copy.
 * 7) Select cell B3.
 * 8) 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.

Additional query words: XL97 8.0 8.00 PasteSpecial Nonadjacent incorrect

Keywords: kbbug KB159958

-

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

© Microsoft Corporation. All rights reserved.