External References

 

Create External Reference | Alert | Edit Links

An external reference in Excel is a reference to a cell or range of cells in another workbook. Below you can find the workbooks of three divisions (North, Mid and South).

North

Mid

South

Create External Reference

To create an external reference, execute the following steps.

1. Open all workbooks.

2. In the Company workbook, select cell B2 and type the equal sign =

3. On the View tab, click Switch Windows and then click North.

External References in Excel

4. In the North workbook, select cell B2 and type a +

Select Cell

5. Repeat step 3 and 4 for the Mid and South workbook.

6. Remove the $ symbols in the formula of cell B2 and copy the formula to the other cells.

Result.

External References Result

Alert

Close all workbooks. Change a number in the workbook of a division. Close all workbooks again. Open the Company workbook.

A. To update all links, click Enable Content.

B. To not update the links, click the X.

Enable Content

Note: if you see another alert, click Update or Don't Update.

Edit Links

On the Data tab, in the Connections group, click the Edit links symbol to launch the Edit Links dialog box.

Click Edit Links

1. If you didn't update the links, you can still update the links here. Select a workbook and click Update Values to update the links to this workbook. Note how the Status changes to OK.

Update Values

2. If you don't want to display the alert and update the links automatically, Click Startup Prompt, select the third option, and click OK.

Don't Display Alert and Update Links