#NAME and INDIRECT.EXT (broken?)

[jjs]

Cell looks like this
=INDIRECT.EXT("'K:\CP\["&A4&".xls]Exam1'!$E$8")

Cell A4 contains the string "test" and there is a file named "test.xls"

When I completed the sheet this all worked.
When I closed it and opened it again all I get are #NAME? errors.
If I go into each cell (and there are hundreds of them) and "pretend" to
edit the cell with the INDIRECT.EXT reference, then it works for that cell.

What have I done wrong?

 

[Arvi Laanemets]

Hi

INDIRECT doesn't work with closed source file. When you open at same time
the workbook which is referred in cell A4, the formula will work - until you
close the source workbook again. It is a reason, I myself use INDIRECT to
refer inside workbook only.


Arvi Laanemets

 

[jjs]

Hi

INDIRECT doesn't work with closed source file. When you open at same time
the workbook which is referred in cell A4, the formula will work - until
you
close the source workbook again. It is a reason, I myself use INDIRECT to
refer inside workbook only.

Misunderstanding. I am using the add-in called INDIRECT.EXT.

 

[jjs]

Hi

INDIRECT doesn't work with closed source file.

Just a little more information. INDIRECT.EXT does work with closed files.
The error is #NAME, not #REF which you might be getting.

 

[Arvi Laanemets]

Hi

Sorry then! I never used this - is it some 3rd-party add-in, or simply an
UDF?


Arvi Laanemets

 

[Frank Kabel]

Hi
does hitting F9 helps to re-calculate the cells? (Could be that just
the number of cells using this UDF is too much)

 

[jjs]

Hi
does hitting F9 helps to re-calculate the cells? (Could be that just
the number of cells using this UDF is too much)

No, hitting F9 did not help. I deleted the rows and copied them back into
the sheet and it all "came back", so I'm okay now but I don't know why.