how to keep formula don't changed when I copy the file the folder

[miao jie]

Hi, now I'm meet a problem as follow on Excel 2000 and 2003
I have define one function in one Excel file named "file1.xls"
in another excel file(file2.xls) I wanna use the function defined in
file1.xls, so I write the formula as following,
=file1.xls!function1(A1,A2)

in my VBA code, I can sure file2.xls always work with file1.xls together (
that's means when file2.xls reflash, file1.xls always be opened)

my problem is: when I copy the file2.xls to another folder and file1.xls
still in current folder(for example: D:\test\test1\file1.xls, and file2.xls
move to C:\test1\file2.xls).

when I reopen file2.xls, the formula will changed to:
='D:\test\test1\file1.xls'!function1(A1,A2).

how I can keep the formula don't change when I copy & move file2.xls, anyone
can help me, thanks in advance !

 

[Gary Brown]

You should put the function in your Personal Workbook "Personal.xls".
Hope this helps,
Gary Brown