LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 11th 08, 03:04 PM posted to microsoft.public.excel.links
external usenet poster
First recorded activity by ExcelBanter: Mar 2007
Posts: 47
Default links not updating


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
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   Report Post  
Old September 12th 08, 08:19 AM posted to microsoft.public.excel.links
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating links BMA Excel Discussion (Misc queries) 2 July 6th 07 12:46 PM
links not updating? GoBobbyGo Excel Discussion (Misc queries) 7 April 6th 07 12:16 PM
updating links Laura Jean Excel Worksheet Functions 1 August 19th 06 11:07 AM
Updating links Brisbane Rob Excel Discussion (Misc queries) 2 April 1st 06 09:54 PM
Updating links Mike Links and Linking in Excel 1 August 17th 05 01:04 PM

All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017