Excel 2003 Spreadsheet Links
Establishing LinksEditing Links
Startup Prompt
Updating Links
- Select the cell that will have the linked data.
- In the formula bar, type an equal sign (=).
- Then select the worksheet cell that contains the data or text you want linked.
- Press enter.
- The cell’s function area will now display the linked spreadsheet information.
- In the display worksheet, click Edit->Links.
- From this screen you can edit the settings the link files by selecting from the different editing options.
By default when a spreadsheet utilizes links users will receive a prompt when they open the file. Depending upon the location and how you want to use links in your spreadsheet you might want to disable this notification.
To disable this prompt follow the below steps:
- In the display worksheet, click Edit->Links.
- On the lower left portion of the Edit Links window, click the Startup Prompt button.
- Check the “Don’t display the alert and don’t update automatic links” radio button. Then click OK.
If you have made changes to the original and don’t have automatic updates selected you will have to update the link values manually. To update the linked values follow the below steps:
- In the display worksheet, click Edit->Links.
- Click the Update Values and then click Close.
