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.

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.

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.

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.