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.