Linking issues
 

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
DataEdit Linkssheet1 update values. Im looking for a way to auto update
for people who are not computer or excel smart.

Linking issues
 

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

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
DataEdit Linkssheet1 update values. Im looking for a way to auto update
for people who are not computer or excel smart.

Linking issues
 

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 .

"Daniel.C" wrote:

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

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
DataEdit Linkssheet1 update values. Im looking for a way to auto update
for people who are not computer or excel smart.

Linking issues
 

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

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 .

"Daniel.C" wrote:

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

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 DataEdit Linkssheet1 update values. Im looking for a way to
auto update for people who are not computer or excel smart.