Hi,

When I refer to a cell in another spreadsheet, the cell reference always
automatically defaults to absolute (e.g. $A$4). In most cases I don't want
the $ so have to manually remove them which is time consuming.

Is there a way to change the options in Excel 2003 so that the $'s don't
appear ?

Thanks