Making All Identical Names in a Workbook Local (104501)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q104501 SUMMARY
In Microsoft Excel, a defined name can be either global or local.
When you move or copy a sheet containing one or more names that
duplicate global names in the destination workbook, the names on the
newly added sheet are converted to local names. Names that are not
duplicates, remain global names. This combination of identical names
that are global on one sheet and local on others may be confusing and
possibly return unexpected results if it isn't clear which names are
global, which are local, and how to refer to the correct one.
The following information discusses global and local names and how you
can refer to the name you want to use. It also provides an easy method
for making all duplicate names in a workbook local.
Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
---|
Keywords: | KB104501 |
---|
|