Microsoft KB Archive/112633

= 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.