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 workbook is opened second, Excel deletes all sheet-scoped names that the report workbook references in the database workbook.
This advice doesn’t mean much if you don’t use sheet-scoped names. So let’s talk about the scope of range names by first talking about print ranges… [click to continue...]
{ Comments on this entry are closed }
