linking to other workbooks

[Hervinder]

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

[Don Guillett]

pls post in ONE group only

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Hervinder" <Hervinder@discussions.microsoft.com> wrote in message
news:45BCAF5F-67A6-4C6E-9602-5C94245626BD@microsoft.com...
>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