In Excel2000, I have an Offset formula that works on a closed file.I
have read that the Offset function does not work on closed files. How
else can I do this? I don't want to use a Vlookup or Index Match
because of the way the data is layed out in the source file ( many tabs
with data all over the place).My formula is below:

=OFFSET('[Jul06 Ebit-STD.xls]RTW'!$I$4,0,2)

thanks