Visit for more, including Excel Consulting, Macros, and Tutorials.
This Excel Video Tutorial shows you how to diagnose, check, and repair external data connections between multiple workbooks in Excel. You will learn how to check the status of a connection to see if it needs to be repaired or updated and then how to search your computer to find the correct Excel workbook to which you need to link in order to fix the original workbook.
This is a great tutorial to view if you often work with workbooks that reference external workbooks for information and you need help troubleshooting some problems. In essence, this tutorial teaches you how to edit the links within your workbooks.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.