Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update
"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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto update
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update | New Users to Excel | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
auto update | Excel Worksheet Functions | |||
auto update | Excel Worksheet Functions |