INDIRECT formula probs!

I

ianripping

In Cell A1 I have :-

="'H:\[Book1.xls]Sheet1'!$A$1"

In cell A2 I have :-

=indirect(a1)

The answer comes out as REF!

whats wrong?

the files there, there is text in the cell referenc
 
F

Frank Kabel

Hi
INDIRECT only works with open workbooks. I assume that your other
workbook 'Book1.xls' is NOT open.

Alternatives:

If the other workbook is closed try the following: have a look at the
Add-In MOREFUNC.XLL
(http://longre.free.fr/english)

use the function INDIRECT.EXT.e.g. (if cell A1 stores the reference)
use:

=INDIRECT.EXT(A1)

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u
 
Top