Linked Workbooks

[jlojones821]

I'm saving several workbooks in one file and then I have a master sheet that
all of the information is linked to. If one of the workbooks is unavailable
is there a formula to simply update those cells with a zero amount?