It is always a good idea to use names within Excel instead of pure references ($A:$A). Formulas are easier to read and the maintenance of the workbook and of the profile file is facilitated.
The samples provided with ODBCFace will give you a good idea how to use Names instead of references in an Excel workbook.