I have a spreadsheet that is linked to quite a few other workbooks all of
which are saved in various diferent locations on our server.

The problem i am having is that when i save the workbook and reopen it the
links to the other workbooks have been lost and i have to relink them.

I have had this problem a long time ago and the only way around it was to
save all linked workbooks as a workspace so they all open together.

Is this the only way around it or is there another solution?

thank you
Hervinder