Hi Folks -
We are using external links to create a grading sheet for instructors to
populate student names, dates, other text data. (Our school's database
exports this information into a csv file based on a query) Most of our staff
neither knows nor cares how it works - unfortunately I am having a heck of a
time getting the links to update without opening the source file and fear
that staff will become frustrated and not use the tool.

1. I get the Security Warning in the status bar stating that Automatic
update of links has been disabled. Once I clear that

2. I get a message stating: Excel cannot update one or more links in this
workbook. To update the links, open all the link source files and press F9
to update calculations

Is there a way to disable this and update the links automatically, and will
it make our network admins crazy (meaning does it leave the door open to
bigger problems).

Thanks!!!!!!