Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104999

From BetaArchive Wiki
Knowledge Base


Global Names and Local Names Use Same Amount of Memory

Article ID: 104999

Article Last Modified on 8/15/2003



APPLIES TO

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 for Macintosh



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"


Additional query words: 97 98 XL98 XL97 XL7 XL5 XL

Keywords: KB104999