When ever you open a file with external link it will ask for updating of values. But if you are already working on file and you want to update it at later stage. This can be achieved without closing and opening file again.
manually update External Links in Excel 2010
- Open Excel Sheet with external links
- Go to Data tab -> Connections
- Now Click on Edit Links.
- Click on Link you want to update. Click on Update Values.
In case you want to make multiple selective selection click use CTRL+click or if you want to select all use CTRL+A.