A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

links not updating



 
 
Thread Tools Display Modes
  #1  
Old September 11th, 2008, 03:04 PM posted to microsoft.public.excel.links
Paulo
external usenet poster
 
Posts: 51
Default 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  
Old September 12th, 2008, 08:19 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.