I have a destination workbook with links to multiple source workbooks. The
majority of links work correctly in the destination workbook to display
information that is in the cells of the source workbooks, even when the
source workbooks are closed. However, there are several cells in the
destination workbook that return #N/A from the linked source workbook if the
source workbook is closed. If I open the source workbook the cells display
the correct values. Why do the linked cells in the destination workbook
display correctly in some cells and return #N/A in others? How can change it?
BTW, the linked source workbooks where I'm having the problem contain text
values.