Resummit auto update
 

I poated this question earlier and received one response that did not help,
probally because I did not include enough information.
I have several spreadsheets that update from a common input sheet to monitor
a wastewater plants yearly process control. At the end of the year I saveas
2009 break links so I could start 2010. I wiped out the data on the input
sheet and started over. The problem is now when you open one of the sheets
that draw from the input sheet it tells me this workbook contains one or more
links that could not be updated. When my coworkers try to open it says auto
update turned off.
I go to edit links and update values and it will update but would prefer
it do it automaticly as there are multiple sheets and this takes some time.
Last year it did update when you opened the sheets as long as the input sheet
was open.
Did I not do this correctly and is there a way of turning auto updates on.
In edit links automatic is checked and so is do not display alert and update
links.
I am using 2007.