linked files pulling #value if source is not open

[bauerbach]

maybe this is just how it is? but it seems pretty silly.

Is there anyway to either get these values to actually look at the source to update? or atleast hold their last known value till the linked file is opened for an update?

It didnt start to act up till I put an offset onto the file link, I guess thats more than it can do without opening the file?

for an example

Please Login or Register  to view this content.

the whole offset reference pulls a #value if the 'summary of June 2012_V2.xls' is not open.

[dilipandey]

Hi baurebach,

Like you have given full file path for "12ProdFcstModel_6+6.xlsm", use the full path of 'summary of June 2012_V2.xls' as well in the formula. May be this can work.
Also, if you wish to avoid the #value, you can use iferror function like =iferror(<your formula>,""). Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>