Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
links not updating
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating links | Excel Discussion (Misc queries) | |||
links not updating? | Excel Discussion (Misc queries) | |||
updating links | Excel Worksheet Functions | |||
Updating links | Excel Discussion (Misc queries) | |||
Updating links | Links and Linking in Excel |