Is it possible to skip the re-selecting of source files when "Updating Values'? I was hoping to have the same effect as the "auto-update" offer of excel upon opening a workbook where one can simply hit "continue" rather than having to manually "edit links" since the source files actually remain the same.

Is this possible? I need this function as it's hard to restart a big excel file (with other opened files).

Please HELP. I have tried my best researching for previous threads on this, but they are often left with no replies... Thank you very much!

I am using Excel 2007 / 2010

If, by chance, there has been a solved case similar to this, please inform me ( of the link to that thread) as I have not been able to find it by myself. Thank you!