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?
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?