Microsoft® Office 2013 QuickSteps by Carole Matthews

Author:Carole Matthews
Language: eng
Format: epub
Tags: -
Publisher: McGraw-Hill Education
Published: 2013-06-20T04:00:00+00:00

CAUTION If you break an external reference link in the Edit Links dialog box, all formulas using external references are converted to values. Broken links cannot be undone except by reestablishing the links.

4. Click Close when finished.

Add a Symbolic Formula

Another way to add a formula, though it won’t work as one, is to use the Equation Editor, an Office-wide tool. This will allow you to display the characters of a complex formula without actually performing the calculation. To install the Equation Editor (it is not part of an Express Office installation):

1. Click Start, click Control Panel, and then under Programs, click Uninstall A Program. Select your version of Office, and click Change.

2. In the Change Your Installation Of Microsoft Office dialog box, click Add Or Remove Features, and click Continue. Click the plus sign (+) next to Office Tools, and click the Equation Editor down arrow.

3. Click Run From My Computer, and click Continue.

4. To use the Equation Editor, restart Excel, select where you want the equation placed, and then in the Insert tab Symbols group, click Equation.

Update Links

When you open a destination workbook with external links to source workbooks, you are potentially introducing a security risk to your computer by allowing data from other sources into your system. By default, automatic updating is disabled and the user opening a destination workbook needs to provide permission to enable the links (unless the source workbooks are open on the same computer as the destination workbook). If you are unsure of the origination of the source workbooks when updating links in a destination workbook, open the Edit Links dialog box to view the files involved in the links. See how in the recent section “Update and Manage External References.”

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.