View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fightin Engineer Fightin Engineer is offline
external usenet poster
 
Posts: 1
Default References to external workbooks in excel

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?