As some of you may be aware, Excel 2007 has been exhibiting an obscure but very annoying bug. On some rare occasions, Range Names may disappear from your workbook after saving it.
I have never been able to detect any pattern in this behaviour, it just happens on and off.
I’m happy to say Microsoft created a hotfix for this bug.
###EDIT 2009-07-06 15:10 GMT: fixed a small mistake, you need SP1, NOT SP2###
Make sure you have Office 2007 updated to at least SP1; visit Microsoft Update to check if you need it.
After that, visit the hotfix page and request your hotfix download.
For more information about range names, read my series of articles on them here.
And if you use range names frequently (or plan to in future) do yourself a favour and download Name Manager.
Jan Karel Pieterse