How to manually update External Links in Excel 2010

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

  1. Open Excel Sheet with external links
  2. Go to Data tab -> Connections

    Update External Links in Excel

    Update External Links in Excel

  3. Now Click on Edit Links.Manually update External Links in Excel
  4. 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.