Edit Link options. When you open the Edit Links dialog (Data > Queries & Connections > Edit Links), you're presented with several options for dealing with existing links. You can select individual workbooks with Ctrl+click, or all of them with Ctrl+A. This will update all selected workbooks.