I am using Excel version 2002. In previous versions I have been able to just
type in the path to the workbook I am linking to. In this version everytime
I key a the path to the link example: =([budget.xls]nov05!c5) it opens the
file directory in which you are working and wants you to select the file [by
clicking it], and then click "open".

Is there anyway to make excel recognize the file name without having to
click the link everytime? It is very time consuming to click the link
everytime, as at the moment we have 12 sheets in the workbook with
approximately 120 links.

Any tips would be appreciated. Thanks!