external linking in OFFSET

[Petricore]

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.

[teylyn]

Hi,

OFFSET is one of the functions that can not reference to closed workbooks. Maybe you can work out something with INDEX or MATCH instead.

cheers

[Petricore]

Thanks for the advice, I fixed it by doing the offset in the remote sheet in a new tab and just referencing that in the master sheet.