I am using Excel 2000, it fills the rest of the column if you type
[Week33.xls] in the first cell and [Week34.xls] the second. And then you
drag the two cells to down below, it would fill up the number [Week35.xls],
[Week36.xls], [Week37.xls] and so on.
Another stupid workaround is that if you construct your worksheet as below
Cell A1 - "[Week"
Cell B1 - 33
Cell C1 - ".xls]Sheet1!$B$4"
Cell D1 - A1 & B1 & C1
Copy entire column D
Replace all "[" to "=[" at column D
"Linas Petkevičius" ?????
...
Autofill the [Week33.xls] part first, change all "]" to "]Sheet1!$B$4",
and
then change all "[" to "=["
Autofill works with Week33, but not with [Week33.xls]. Maybe there is
solution like using INDIRECT(), but without opening linked files ? In excell
4.0 there was function EVALUATE(). Where is it now ? I have found some user
created, but they don't work with external links, when they are closed
(
Please help !!!
|