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


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

This article was previously published under Q104999


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.


"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