Link not updated everytime spreadsheet opened
 

Dear All,

In our network, we have several spreadsheets that contain links to others.

Using the Vlookups functions, a spreadsheet looks for information on other
spreadhseets and updates them.

Unfortunately, we have no warning that the links are not updated. They are
not updated most of the time. Sometime they are.
Even if the underlying file is opened, the links are not updated.

We have to manually update the links by going to edit, links and then open
source.

Why are my formulas not working from time to time ?

This does not happen on all spreadsheets and the problem happens from a
sreadsheet or another.

It is really happening sporadically.

This might help, we have changed the file server where the spreadsheets used
to be. Since then we have this problem.

Please assist us as we are desespeate.

Thanks in advance.

Kind regards,

Olivier De Visscher