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

ID: Q104999

The information in this article applies to:

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

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 :