Cell reference within a indirect..

[Hurtige]

Im really in need of some good advice. Ive used many hours making a test
cell for a new worksheet, but then when i closed down the workbooks my
test cell was refering to i got the #REF! error although the whole path
to the workbook was there. I isolated the problem to a indirect formula
im using because i want the reference file to be a variable.

How do i solve the problem that excel isnt able to use a cell reference
in a workbook that isnt open if that reference is within a "=indirect()"
code..?

 

[paul]

http://www.dailydoseofexcel.com/archives/2004/12/01/indirect-and-closed-workbooks/
try this function called indirect.ext

 

[Hurtige]

Thanks.. To bad it has limitations.. I needed it for looking up if
excel workbook have been completed for each of 60.000 persons.. But
guess we will have to keep track of how many workbooks have been mad
manually :