Linking Excel Workbooks

[Lee Holder]

I'm linking data from several workbooks into one master
workbook. Most of the fields are linking correctly.
However, 1 specific field in the master workbook linking
displays "#N/A" While I keep the master book open and bring
up the other corresponding file in question....The master
books field updates correctly. Once the file closes the
master book's field goes back to the "#N/A" It's very
nerve racking. The field that this happens with is a work
schedule (Ex. 7:00pm-3:30pm)

 

[Anon]

I'm linking data from several workbooks into one master
workbook. Most of the fields are linking correctly.
However, 1 specific field in the master workbook linking
displays "#N/A" While I keep the master book open and bring
up the other corresponding file in question....The master
books field updates correctly. Once the file closes the
master book's field goes back to the "#N/A" It's very
nerve racking. The field that this happens with is a work
schedule (Ex. 7:00pm-3:30pm)

Is the link reference within a function? Some functions work with closed
workbooks whilst others do not.