Creating notebook links
You can insert links into Quattro Pro notebooks. There are several advantages to setting up notebook links instead of using multisheet notebooks. You can eliminate redundancy, ensure data is always up to date, save disk space, divide tasks among several people, and build larger models that exceed the limits of a single notebook.
You can link notebooks by selecting cells in the source notebook (when both notebooks are open). When you are consolidating information from several files that have the same layout, you can use wildcards to link to the same place in all of them. You can also link cells.
Links between Quattro Pro and other applications can be created. For example, you can write a memo in WordPerfect and link a cell in Quattro Pro to it.
You can create hyperlinks in a notebook to jump to another file or an Internet site.
To insert a notebook link |  |
|
1.
|
|
Select a cell in which you want to place a link.
|
|
2.
|
|
Type a plus sign (+), and type the link address as [Drive:\Path\Filename.Extension]Sheet:Cell reference, where:
|
|
•
|
Drive — is the drive containing the notebook. This is necessary only if the notebook you are linking is not on the same drive as the primary notebook.
|
|
•
|
Path — is the path to the folder containing the notebook. This is necessary only when the notebook is not in the same folder as the primary notebook.
|
|
•
|
Filename — is the name of the notebook
|
|
•
|
Extension — is a three-letter suffix separated from the filename by a period (.). It is necessary only when the notebook has a different extension from the primary notebook.
|
|
•
|
Sheet — is any valid sheet name, sheet range, or group name (such as C, Sales, D..F, or YearToDate)
|
|
•
|
Cell reference — is any valid cell address, pair of coordinates, or cell name. However, cell coordinates are valid only when the link contains a spreadsheet function to operate on the cells.
|
|
•
|
|
Because link statements are not case-sensitive, you can type all parts of the link in either uppercase or lowercase. Do not include blank spaces in any part of the reference.
|
To link notebooks by selecting cells | |
|
1.
|
|
Click File
 Open. |
|
2.
|
|
Choose the drive and folder where the notebook is stored.
|
|
3.
|
|
Double-click the filename.
|
|
4.
|
|
Select a cell.
|
|
5.
|
|
Type a plus sign (+) in the cell.
|
|
6.
|
|
On the application bar, click the name of the supporting file.
|
|
7.
|
|
Click the cell that contains the link you want to place in the primary notebook.
|
|
If the formula is incomplete, finish typing it.
|
|
8.
|
|
Press Enter.
|
|
•
|
|
You can also activate the target notebook by clicking Window and choosing the window from the numbered list at the bottom of the menu.
|
To link notebooks by using wildcards | |
|
1.
|
|
Click File
Open. |
|
2.
|
|
Open the primary notebook and any relevant supporting files.
|
|
3.
|
|
Type a wildcard character in place of the filenames in the link.
|
|
•
|
|
You can use the wildcards question mark (?) and asterisk (*) in links. A question mark (?) represents any single character, and an asterisk (*) represents any number of characters. For additional information, see “File-handling options.”
|
To link cells | |
|
1.
|
|
In the source notebook, select the cells you want to link.
|
|
2.
|
|
Click Edit
Copy. |
|
3.
|
|
In the destination notebook, select the upper-left cell of the destination cells for the links.
|
|
4.
|
|
Click Edit
Paste special. |
|
5.
|
|
Click Link.
|
To link data between applications | |
|
1.
|
|
In the source application, select the data you want to link to from Quattro Pro.
|
|
2.
|
|
Click Edit
Copy. |
|
3.
|
|
In Quattro Pro, click the cell where you want to place the linked data.
|
|
4.
|
|
Click Edit
Paste special. |
|
5.
|
|
Enable the Paste link option.
|
|
6.
|
|
Choose a file format from the As box.
|
|
•
|
|
You can link contiguous and noncontiguous selections.
|
To insert a hyperlink | |
|
1.
|
|
Select a cell on the active spreadsheet.
|
|
2.
|
|
Click Tools
Hyperlink. |
|
3.
|
|
Type a text description of the link in the Text to link box.
|
|
4.
|
|
Type a link source in one of the following boxes:
|
|
•
|
Link to file or URL — allows you to link to a file or URL
|
|
•
|
Specific location — allows you to link to a cell address in the same notebook
|
|
•
|
|
You can also create a Web link to a specific Web site, such as one that provides a stock quote. For more information, see “Working with Web links.”
|