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.