I am using two excel files, each in a unique directory. In file A I have
created an OFFSET formula which offsets from Col C, Row 3, in file B. using a
cell value in file A to determine the row_number to offset to.

This worked fine while I was working with both files open. After I saved
file A and closed file B, I reopened file A only to find #VALUE! in the cell
where the OFFSET formula was. How do I get around that?

Post your formula, you can use INDEX instead of OFFSET in many case and it
will work when the source workbook is closed


--


Regards,


Peo Sjoblom



"txm49" wrote in message
...
I am using two excel files, each in a unique directory. In file A I have
created an OFFSET formula which offsets from Col C, Row 3, in file B.
using a
cell value in file A to determine the row_number to offset to.

This worked fine while I was working with both files open. After I saved
file A and closed file B, I reopened file A only to find #VALUE! in the
cell
where the OFFSET formula was. How do I get around that?

Here's for formula -
=OFFSET('[SE Region LD Weekly Metrics 10_8_2007.xls]Cons Cust.
Summary'!$C$4,($G$14),0)

The formula in $g$14 in the "host" excel file is -

=MATCH($B$14,'[SE Region LD Weekly Metrics 10_8_2007.xls]Cons Cust.
Summary'!$C$4,0)+3

Thanks!

"Peo Sjoblom" wrote:

Post your formula, you can use INDEX instead of OFFSET in many case and it
will work when the source workbook is closed


--


Regards,


Peo Sjoblom



"txm49" wrote in message
...
I am using two excel files, each in a unique directory. In file A I have
created an OFFSET formula which offsets from Col C, Row 3, in file B.
using a
cell value in file A to determine the row_number to offset to.

This worked fine while I was working with both files open. After I saved
file A and closed file B, I reopened file A only to find #VALUE! in the
cell
where the OFFSET formula was. How do I get around that?