2012

To remove a link to an external spreadsheet
1 Click inside a cell within the data linked table to select the cell.
2 Right-click and click Data Links ➤ Detach Data Link.
To set up a named range in Microsoft Excel
1 In Microsoft Excel, open the workbook or spreadsheet that you want to
access.
2 Select a range of cells to function as a linked range.
3 In the Name Box, enter a name for the range of cells, then press Enter.
4 Repeat steps 2 and 3, if desired, to specify additional linked ranges.
5 On the File menu (Microsoft Excel), choose Save.
To open an external spreadsheet from a data link
1 Select any cell in the linked table or range of linked cells.
2 Right-click and click Data Links ➤ Open Data Link File.
Quick Reference
DATALINK
Displays the Data Link dialog box.
DATALINKUPDATE
Updates data to or from an established external data link.
DATALINKNOTIFY
Controls the notification for updated or missing data links.
Work with Table Styles
The appearance of the table is controlled by its table style. You can use the
default table style, STANDARD, or create your own table styles.
When you create a new table style, you can specify a starting table. A starting
table is a table in your drawing that is used as an example for formatting the
1044 | Chapter 27 Tables