References to external workbooks in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top