#NAME and INDIRECT.EXT (broken?)

  • Thread starter Thread starter jjs
  • Start date Start date
J

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?
 
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
 
Arvi Laanemets said:
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.
Click to expand...

Misunderstanding. I am using the add-in called INDIRECT.EXT.
 
Arvi Laanemets said:
Hi

INDIRECT doesn't work with closed source file.
Click to expand...

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

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


Arvi Laanemets
 
Hi
does hitting F9 helps to re-calculate the cells? (Could be that just
the number of cells using this UDF is too much)
 
Frank Kabel said:
Hi
does hitting F9 helps to re-calculate the cells? (Could be that just
the number of cells using this UDF is too much)
Click to expand...

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. :(
 
Back
Top