Microsoft Knowledge Base

XL: Copy-Paste Link of Named Range Doesn't Link to Name
Last reviewed: June 5, 1997
Article ID: Q112633
5.00 5.00c 7.00 7.00a 97 | 5.00 5.00a 
WINDOWS                  | MACINTOSH
kbusage

The information in this article applies to:

  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel 97 for Windows

SUMMARY

In Microsoft Excel, if a cell that has a defined name is copied and then linked to another cell, the formula created will be linked to the cell itself, not to the defined name.

MORE INFORMATION

In earlier versions of Microsoft Excel, if a cell was copied and linked to another cell in that worksheet, the linking formula would link to the name of the cell. For instance, if a cell called "Sales" was copied, then linked to another location, the linked formula would be "=Sales" (without the quotation marks). However, in Microsoft Excel versions 5.0 and later, the formula contains the specific cell that was copied, not the range name. Therefore, the resulting formula might be "=$B$4" if the name Sales referred to cell B4.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a 97

Keywords : kbusage
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 5, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.