I use xl2003 and it works the nice way you describe.

My first guess is that you are mistyping something--either the workbook name or
sheet name.

Or maybe...

In my simple tests, it sure looked like xl just used the default folder location
to get the correct path. Could it be that your file isn't in that location?

sparklydaisy wrote:

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!

--

Dave Peterson