Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
The following articles are available for the 'Linking Workbooks' topic. Click the article's title (shown in bold) to see the associated article.
Don't Update Links to Other Programs
If you have links in your workbook to data in other workbooks, you may want to control whether Excel updates those links or not. Here's how to find the settings that Excel uses for that purpose.
Easily Changing Links
If you have linked information in your worksheets, you may want a way you can easily change the targets to which those links are pointing. One way you can do this is to make the links dynamic, using the INDIRECT worksheet function.
Errors when Copying References to External Cells
If you copy a cell that contains a reference to external data, do you get an error? It could be due to the complexity of the information contained in the formula referencing the external data.
Getting Rid of Workbook Links
Excel allows you to easily link information from one workbook to another. If you want to get rid of links that may be within a workbook, there are a couple of ways you can accomplish the task.
Replacing Links with Values
Need to get rid of the links in your workbook but save the values that were retrieved by those links? It could be easy or hard, depending on the complexity of your workbook. Here are some great ideas you can try.
Simple Relative References in External Links
Linked data can be essential in pulling information from one workbook to another. One downside of links, however, is that they can be rather inflexible in their references.
Uncovering and Removing Links
Excel allows you to reference data in other workbooks by establishing links to that data. If you later want to get rid of those links, it can be tedious to track them all down. Here are the majority of the places you should look for links in your workbook.
When you establish links between data on a target worksheet and data on a source worksheet, those links are typically updated when you open the target workbook or choose to print the workbook. If you want to manually update the links at some other time, however, you can use the steps in this tip.
Updating Links in Copied Files
When you copy workbooks that contain links, you may be at a loss as to how to update those links. There are a couple of ways you can approach the task, as discussed in this tip.