Global Names and Local Names Use Same Amount of Memory (104999)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q104999

SUMMARY

There are two types of defined names: global names and local names. Global names are available to the entire workbook and local names are available only to the sheet where they are defined. The amount of system resources and/or memory used by global and local names are the same.

NOTE: In Microsoft Excel versions 5.0 and later, local names behave similarly to defined names in earlier versions of Microsoft Excel.

REFERENCES

"User's Guide," version 5.0, Chapter 10, "Names Make References Easier to Use"
Modification Type:MinorLast Reviewed:8/15/2003
Keywords:KB104999
©2003 Microsoft Corporation. All rights reserved.