I like David's idea, but I think you should move the worksheet(s), then do all
your formulas, then move the worksheet(s) back.

Then the links will adjust to the correct workbook, too.

ChrisK wrote:

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

--

Dave Peterson