External links contain too much text
 

Hi,

I have a number of spreadsheets set up for different users too have one each
they enter comments into a cell on each spreadheet,

this is then all pulled onto one spreadsheet but as they are external links
theyonly pull across part of the details, unless the external workbooks are
open.

it works with some when the linked book is open but only when the linked
book is on the same drive as the main book and i have some linked books that
are stored on a drive that is different

could anyone help me with this