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 went 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.

In Excel 2003, try Tools, Options, Edit Tab, towards the bottom, uncheck "Ask
to update automatic links"

As long as the linked file is fine and everything else is working, this
might be your solution. Now, it seems as though each user has to turn this
option off on their own pc.



"Jerry R" wrote:

> 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 went 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.

"Kevin Barrios" wrote:

> In Excel 2003, try Tools, Options, Edit Tab, towards the bottom, uncheck "Ask
> to update automatic links"
>
> As long as the linked file is fine and everything else is working, this
> might be your solution. Now, it seems as though each user has to turn this
> option off on their own pc.
>
>
>
> "Jerry R" wrote:
>
> > 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 went 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.

Using 2007. In edit links automatic is checked. Also in startup prompts have
checked do not display alert update links.

"Jerry R" wrote:

>
>
> "Kevin Barrios" wrote:
>
> > In Excel 2003, try Tools, Options, Edit Tab, towards the bottom, uncheck "Ask
> > to update automatic links"
> >
> > As long as the linked file is fine and everything else is working, this
> > might be your solution. Now, it seems as though each user has to turn this
> > option off on their own pc.
> >
> >
> >
> > "Jerry R" wrote:
> >
> > > 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 went 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.