In Excel Bug Deletes Some External Range Names Automatically I discussed a bug that exists in Excel 2007 and in the beta of Excel 2010. Here’s the summary of that entry:
When Excel range names in a report workbook reference sheet-scoped names in a database workbook, if the report workbook is opened first and the database [...]
From the category archives: