Linking Excel Workbooks

  • Thread starter Thread starter Lee Holder
  • Start date Start date
L

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)
 
Lee Holder said:
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)
Click to expand...

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