S
SU
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.
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.