Microsoft Office Tutorials and References
In Depth Information
Copying, cutting, and pasting in linked workbooks
Click Break Link to convert all existing external references in formulas to their current
values. You can’t undo this action, so proceed with caution.
Click Update Values to fetch the latest figures from the supporting workbook without
having to open it.
You can link objects and documents created in other applications, such as Word, to
Excel worksheets and charts. When you do so, the Type column displays the
application name and the object type.
Clicking the Startup Prompt button displays the Startup Prompt dialog box shown in Figure
12-38. You can use this dialog box to specify how links are handled whenever the
workbook is opened.
Figure 12-38 The Startup Prompt dialog box lets you customize the startup behavior of external
Ordinarily, Excel displays a security alert when you open a workbook containing linking
formulas, which individual Excel users can choose to suppress on their computers. If you prefer
to suppress the security alert for the current workbook, you can do so by selecting either
Don’t Display The Alert And Don’t Update Automatic Links or Don’t Display The Alert And
Update Links in the Startup Prompt dialog box.
To change the default behavior of disabling automatic links, click the File tab, Options,
Advanced category, and then in the General section clear the Ask To Update Automatic
Links option.
Copying, cutting, and pasting in linked workbooks
You can use relative or absolute references to cells in other workbooks as you do in a single
workbook. Relative and absolute references to cells in supporting workbooks respond to
the Copy, Cut, and Paste commands and buttons in much the same way as do references to
cells in the same workbook.
Search JabSto ::

Custom Search