You can not refernce a closed file using INDIRECT, here's a workaround

http://www.google.com/groups?selm=sH...wsranger. com

On one line

how to install macros

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Regards,

Peo Sjoblom



"briancrosier" wrote:

I am using the indirect function to reference cells in another Workbook. I
would like the reference to the files without them being open. Is there a
way to do this?
I was told that it can be done by using the full file path in the reference?
Is this true? How should it be entered?