Microsoft fixes Excel name range bug

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.



Range names

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.

 

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.