Indirect function giving #REF! error

Hi,

I'm using the INDIRECT fucntion in a cell, reffering to another where is written the following:

Please Login or Register  to view this content.

As you can see, the text points to another file and to a specific cell named "COMPANY".

The problem is that when the file "Data.xls" is opened, the INDIRECT function gives me the correct value, but when i close it, the cell gives ne #REF! error.
Is there any way of the cell with the INDIRECT function gives the correct value all the time and not only when the reffered file is opened?

Thanks!

Thanks dilipandey,

Is there any when that i can do the same but with the workboo closed?

Thanks

Dear DILIPandey,

Thank you once more for the tip.

But what if i want to use that code, but instead of writing the location of the file as you mentioned (between commas), what if i want to do the same but reffering a specific cell where i have the same text

Please Login or Register  to view this content.

.

Thanks

Deart dilipandey,

Sorry in my delay...
Thanks for yur help. I think i solved my problem!

Thanks!