Setting Advanced Options

In addition to display options, the Advanced pane in Excel options also includes options when performing calculations in a workbook and when providing general user feedback. You can set the precision option to permanently change stored values in cells from full precision (15 digits) to the current format, or you can set the feedback options to play sound, show add-in user interface error, or display alerts to update links. If you want to open one or more specific files when you start Excel, you can specify a folder in Advanced options.

Change Advanced Options

Image Click the File tab, and then click Options.

In the left pane, ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.