Indirect.ext pulls only first 255 characters of closed file

[hond70]

Help, this is a disaster... I discovered that indirect.ext (add in of morefunc) only pulls the first 255 characters of the contents of a cell, when the target file is closed. It pulls out the 1024 characters when both files are open.
This is not where indirect.ext was designed for.

Anybody has a solution?

I use formulas like
=IF(ISERROR(SETV(INDIRECT.EXT("'"&Locaties!$A$1&"["&A11&".xls]"&$C$3&"'!$B$"&$D$3)));"";IF(GETV() <> 0;GETV();""))
and
=IF(ISERROR(INDIRECT.EXT("'"&Locaties!$A$1&"["&A10&".xls]"&$C$3&"'!$B$"&$D$3));"";INDIRECT.EXT("'"&Locaties!$A$1&"["&A10&".xls]"&$C$3&"'!$B$"&$D$3))

 

[FastExcel]

Re: Indirect.ext pulls only first 255 characters of closed f

Thats a different question and I dont see the answer?

 

[hond70]

Re: Indirect.ext pulls only first 255 characters of closed f

It's a refrased question. There is no solution for avoiding the 255 character limit with indirect.ext or the Grove's pull function, when the source file is closed. So you have to open the source file.

My problem was that I have more than 100 source files and I can't open them all together. And when I open the first 10, read the data and then open the second batch of files, all the cells of the first batch containing more than 255 characters were cut back to 255....

With the solution given at experts-exchange I am able to read the second batch without loosing the read data of the first batch.

Success!