Chapter 7 continued ...
Canceling the message about creating links when opening a workbook
1. From the Tools menu, select Options, and then select the Edit tab.
2. On the Edit tab, clear the selection of the Ask to update automatic links box.
From the Edit menu, select Links.
| Excel 2002 offers new solutions for handling the problem of links between files. |
New
In |
| |
|
| New
In |
||
| Click the
Startup Prompt button, and define the method of opening
linked files. Select the type of link you want to break, and click Break links. The links between workbooks are broken, and the linked formulas are deleted. |
||
|
|
CautionDouble-check and make a backup copy of the workbook before breaking the links. |
|
Changing a source allows you to change the location of the workbook on the hard disk or to exchange the location of one workbook for another.
1. Select the workbook in the old location.
2. Click Change source.
3. Select the workbook that should be linked in the folder you have opened.
4. Click OK. The location of all linked formulas will change.
Changing links and deleting unwanted links
1. Select a cell in the sheet.
2. Press F3, and click Paste list.
3. Check the list, and identify the Names you want to delete.
4. Press Ctrl+F3.
5. Select the Name to be deleted, and click Delete.
Stage 2 – Check the link in the sheet and find the links that can be deleted
1. Press Ctrl+F.
2. In the Find box, type a square bracket ([). Every externally linked formula has a square bracket.
3. Start the search for formulas one cell at a time.
4. Delete unwanted and unnecessary formulas (do this with care).
Stage 3 – Check the data consolidate dialog
1. From the data menu, select Consolidate. This dialog remembers the last consolidation.
2. If any items in the All References box point to the undesired link, highlight them and click Delete.
Stage 4 – Check the link box
1. From the Edit menu, select Links.
2. Select the name of the workbook whose links you want to delete.
3. Click Change source.
4. In the folder, select the workbook you are currently working in (that is, link the workbook to itself).
5. Click OK.
Copy the cells with the formulas.
2. Right-click, and from the shortcut menu, select Paste special.
3. In Paste, select Values and click OK.