XL: Global Names and Local Names Use Same Amount of Memory

ID: Q104999


The information in this article applies to:


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"

Additional query words: 97 98 XL98 XL97 XL7 XL5


Keywords          : 
Version           : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.0,5.0a,98
Platform          : MACINTOSH WINDOWS 
Issue type        : 

Last Reviewed: April 7, 1999