I have an excel spreadsheet which uses INDIRECT.EXT to read data from about
10 excel files using morefunc 3.241. This worked brilliantly and have never
had any problems.

Recently, I installed the latest version and everything fell apart. The data
is not being read at all.

My codes are as follows:

=IF('Sales'!$J10=0,INDIRECT.EXT('Sales'!$U10& $C10 &".xls]YTD'!$M$6"),"")

where, $U10 value is exactly as follows:

'C:\Expenses and Sales\Equipment Sales\Sales\WA_Region\Sales\2007\Sales2007_

and, $C10 value is exactly as follows:

smithdg

I am afraid, there were reasons why I had to use the above to locate and
name the file.

Can anyone please help, I need this. Many thanks in advance.