We have a document called Beaufort.xls. This documents is on
our network and contains various lists (like currency details
or ship names etc). These list are used in various cells of
various templates I have created.

Normally we first open the file Beaufort.xls and thereafter
one of the templates and that just works fine.

Recently a new colleague joined. However when she opens the
template she gets an error report: €œThe workbook you opened
contains automatic links to information in another
workbook...€� Even when she clicks yes €œto update all linked
information€� this doesnt help, because she cant choose from
a list that should be available in certain cells.

Now I have found the following which may give an indication
for the problem, although Im not sure. On the main menu
under €œEdit€�, €œLinks€� I see the
following:
A. when I first open the Beaufort.xls and then the template it states:
sourcefile: Beaufort.xls

B. when I open the template without the Beaufort.xls file is states:
sourcefile: \\sgfileserver\beaufort$\Beaufort.xls

However when my colleague does the same she gets the
following in both (A and B) situations:
sourcefile: \\sgfileserver\beaufort$\Beaufort.xls

All our templates are stored on:
\\sgfileserver\aplpications\sjablonen
and both her and my office programs refer to those locations