links not updating

hello,

I have a workbook, that is in the network and evrybody uses.
this workbook has formulas such as workday() and eomonth() that uses
analiyst toolpack there fore ATPVBAEN.xla. I also have 2 other third party
formula/add-ins.
The third party add-ins arent essential for the workbook but the analyst
toolpack is.

this workbook was assembled in my computer. and I saved it in the network.
rarely i have to refrech the links to it, as I set my excel to do it
automaticaly without asking.

but the othe computers from the network always have to manualy open the
linkmaneger and manualy refresh the link.
I understand that excel saves ATPVBAEN.xla into its own local file.
I wonder if is that possible to make the sheet or excel use a ATPVBAEN.xla
from a file in the network or there is any othe workarond this problem.

i thank in advance

Sounds to me that maybe your Excel has
- Tools > Options > Edit > Ask to update automatic links unchecked
and the other users have it checked (which is normal)

Also, check whether the setting of Edit > Links > Startup Prompt is
sensible for this workbook.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup