00:00 Find/ deal with External Links in Excel Spreadsheets
01:00 On open you are asked whether to update links
01:49 Find the Edit Links button (in the Data Ribbon in Excel 2007 and later)
02:04 List of all external links in the spreadsheet
02:23 ‘Update Values’ button
02:30 Change all formulas with external links to look at different spreadsheet
03:28 Open the source spreadsheet without manually finding it
03:38 Remove/ break the links to external spreadsheets

How to handle links between spreadsheets. Find the links, change them to look at other spreadsheets or remove them by breaking the link, in Excel 2003.

Still relevant in all the recent versions of Excel including Office 365. In the ribbon the ‘Edit Links’ is in the Data ribbon, almost directly below the Data Ribbon wording.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.