An “an obscure but very annoying” bug in Excel 2007 that occasionally caused Range Names to disappear when workbooks were saved has been corrected by a Microsoft hotfix.
allow you to apply a name to an individual cell, group of cells, formula or constant in Excel so that when you want to refer to the information you can simply type in or choose a range from a pull down menu at the top of the worksheet.
As well as making it much easier to create reference formulae, the logic of arguments containing descriptive names is much more intelligible.
But in recent months Excel experts have reported problems with disappearing range names in the latest version of Excel.
In a post on the Daily dose of Excel blog this month, Pieterse noted that Microsoft had quietly released a hotfix to address the problem. Log in to AccountingWEB for more details.