Linking issues

[lost then found]

Ok I have one wookbook that looks up over like 50 different other workbooks.
But when it finds the data it is looking for it doesnt update unless I do
Data>Edit Links>sheet1> update values. Im looking for a way to auto update
for people who are not computer or excel smart.

 

[Daniel.C]

When you click on "Edit Links", set "Update" to "Automatic" and save
the workbook.
Regards.
Daniel

 

[lost then found]

Thats the way I have it set-up in the workbooks. It works fine when I have
all the different workbooks open on same computer, but when I have sheet A
open on computer 1, sheet B on computer 2, and sheet C open on computer 3 I
have to update manually. Thats the way I need it to work one work book on
different computers and auto update with the realtime data. If you would
like to see what I mean my email is (e-mail address removed).

 

[Daniel.C]

Can't say, I have a stand alone computer. In the same box, click on
"startup prompt" and "don't display the alert and update links". If it
doesn't work, what about a startup macro ?

Private Sub Workbook_Open()
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks
ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks
End Sub

Daniel