Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
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 |