External linking in OFFSET function call...

[spazz41]

I have a call:
=LARGE(OFFSET('M:\Stats\[margin Vendor Weekly Sales and Orders.xls]2009'!$DH$3:$DH$999, 0, $A$4, 1000, 1),X4)

This only works if the margin Vendor Weekly report is open in the same excel session. I want it to work with it closed like the vlookup's I do. Here is an example of a vlookup that works with the sheet closed.
=VLOOKUP(A64,'M:\Stats\[margin Vendor Weekly Sales and Orders.xls]2009'!$C:$HK,110+$A$4,FALSE)

I'm thinking its something with OFFSET, but can't figure it out.

 

[SkipVought]

hi,
[tt]
=LARGE(OFFSET('M:\Stats\[margin Vendor Weekly Sales and Orders.xls]2009'!$DH$3:$DH$999, 0, $A$4, 1000, 1),X4)
[/tt]
what workbook/worksheet is $A$4 in?


Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[spazz41]

$a$4 is in the main sheet that is making that OFFSET call.