XL97: Unexpected Results Paste Linking Noncontiguous Range

ID: Q159958


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


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 : xlformula xlvbmigrate
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: July 2, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.