Everytime I link an cell to another workbook, it automatically puts in an
absolute reference. Is there a setting I can change so I do not have absolute
references appear. This does not happen when you link a cell within the same
sheet only external worksheets.

Thanks