From the category archives:

Just Excel

Set Up Range Names to Connect Reports to Excel Databases, Part 3

September 1, 2009

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 [...]

Read the full article →

Set Up Range Names to Connect Reports to Excel Databases, Part 2

August 27, 2009

Set up references to other workbooks in your range names, not in your formulas. Formulas that use those names will be easier to use, and any problems with your links will be much easier to fix.

Read the full article →

Set Up Range Names to Connect Reports to Excel Databases, Part 1

August 25, 2009

When a formula in one workbook references a range in another workbook, always reference a range name, never a cell address.

Read the full article →

Excel Bug Deletes Some External Range Names Automatically

August 24, 2009

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 in the database workbook.

Read the full article →

Next Entries →