Hi Daniel,
for what I can see you are looking for is to bring the value from cell B3 in
the Basedesloc file so why don't try

=('C:\Documents and Settings\dutsch\Meus
documentos\[basedesloc.xls]Plan1'!$B$3)

It doesn't required the Basedesloc document to be open


"Daniel Utsch" wrote:

Hi, Eduardo

I'm using this formula:

=DESLOC('C:\Documents and Settings\dutsch\Meus
documentos\[basedesloc.xls]Plan1'!$B$3;0;1)

Thanks for your help.

"Eduardo" escreveu:

Hi Daniel,
could you post the formula you are using. thanks

"Daniel Utsch" wrote:

I am using the function OFFSET in a file to look for the values in another
file. But when I close the two files and later I open only the file where
this the function OFFSET, appears me the mistake #VALUE. Para that the values
come correctly, I have to open the two together files. Does anybody know how
I can solve this problem of link? Because the file should be opened daily,
but without opening the origin of the data.

Thanks