Hi Chetyl,
do you want to link workbooks or worksheets ?

Workbooks - i can't help. Worksheets:
you can use the same functionbs as when you doing formulars on the same
worksheet. Just where you want to insert the cell from another sheet in the
same workbook - go there during setting up the formula and select the cell on
that work sheet i.o. on the same. Hope that's clear enough - lol

"cheryl" wrote:

how to get workborks to ling automatically without manully finding the source
file every single time

thanks heaps