in S1.xls
=[E1.xls]Sheet1!A1
will return the value in E1.xls, sheet Sheet1, cell A1 to S1 in the cell
that contains the formula.
E1 must be open when you place the formula (as written - it could be written
with the full path and E1 would not need to be open at the time of creation
of the formula - however, it is easier to have it open at creation).
--
Regards,
Tom Ogilvy
"jill_an " wrote in message
...
Dear experts,
I have several excel files(E1), and one is for summary(S1). I want to
link the sheets in E1 into S1, then when I open S1, I can see the
sheets(only the sheets I linked) data in the S1, also when I update the
E1, the S1 will update too.
Please, thanks.
---
Message posted from http://www.ExcelForum.com/