Bummer. That's what I've been doing, but it slows me down significantly. I
was hoping it was a feature that could be turned off like when excel
automatically generates the "get pivot data" formula when you reference a
cell in a pivot table.

"David McRitchie" wrote:

I suppose you could use a macro but it would probably
be easier to hit F4 to cycle through the different combinations
at the location bar.

http://www.mvps.org/dmcritchie/excel/shortx2k.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fightin Engineer" <Fightin wrote in message
...
99.9% of the time when I'm referencing a cell in another workbook, I want to
use a relative reference (e.g. C7) rather than an absolute reference (e.g.
$C$7). Is there any way to change the default in excel that uses absolute
references when refering to cells in another file?