|
|||
This useful tool allows you to perform a variety of operations with the external and internal links with a workbook. Such operations include the following: External Link When we press the Link's Manager button we will get the dialogue box shown below: |
|||
The following example shows the use of the external links section | |||
In this case we will search the links of the "2007.xls" workbook with "2006.xls" workbook | |||
1.-First you must select a workbook in this case we choose "2007.xls" workbook | |||
2.-In the second section of linked workbooks a list is shown with all references found to other workbooks in the workbook "2007.xls" | |||
Making click in the workbook 2006.xls will obtain cells whose formulas include the 2006.xls workbook and other aditional details. | |||
External links can be viewed in the dialogue box. They can be used to perform a series of operations, such as: Go to cell: This option lets us move to the cell containing the external link. Change source: Taking this option we can exchange the current external link for a new link to a new workbook. Open source: This option lets us open the workbook referred to in a given cell. Update links: It makes it possible to update all links to external files. Internal link |
|||
The following example shows the use of the internal links section | |||
In this case we will search the links of the Sheet1 with Sheet2 | |||
1.First you must select a worksheet in this case we choose Sheet1 | |||
2.In the second Section of linked worksheets a list is shown with all references found to other workbooks in the sheet Sheet1 | |||
Making click in the Sheet2 will obtain cells whose formulas include the Sheet2 and other aditional details. | |||
Additionally, we can perform a series of operations, such as: Break link: It truncates any existing links to another worksheet, but only in the case of the selected cell. Generate report: It generates a detailed report of all internal links found in the workbook. |
|||