Page 78 - Excel 2013 All-in-One For Dummies

60 Exercising Your Options
✦ Use 1904 Date System: Select this check box when you’re dealing with a worksheet created with an earlier Macintosh version of Excel that used 1904 rather than 1900 as date serial number 1.
✦ Web Options: Click this command button to display the Web Options dialog box, where you can modify the options that control how your Excel data appears when viewed with a web browser, such as Internet Explorer.
✦ Edit Custom Lists: Click this command button to create or edit custom lists with the Fill handle. (See Book II, Chapter 1.)
Digging the Data options
The Advanced tab of the Excel Options dialog box now contains a new sec- tion called Data with three check box options. These options control the way that Excel 2013 handles huge amounts of data that you can access in Excel through external data queries discussed in Book VI, Chapter 2 or through Excel’s pivot table feature (especially when using the Power Pivot add-in) discussed Book VII, Chapter 2.
By default, Excel 2013 disables the undo feature when refreshing data in a pivot table created from external data that has more than 300,000 source rows (also called records) to significantly reduce the data refresh time. To modify the minimum number of source rows at which the undo refresh fea- ture is disabled, enter a new number (representing thousands of records) in the text box containing the default value of 300 under the Disable Undo for Large PivotTable Refresh Operations check box or select the new value with the spinner buttons. To enable the undo feature for all refresh operations in your large pivot tables (regardless of how long the refresh operation takes), simply deselect the Disable Undo for Large PivotTable Refresh Operations check box.
Excel 2013 also automatically disables the undo feature for Excel data lists that are created from related external database tables (referred to in Excel as a data model) that exceed 64MB in size. To change the minimum size at which the undo feature is disabled, enter a new number (representing mega- bytes) in the text box containing the default value of 64 under the Disable Undo for Large Data Model Operations check box or select this new value with the spinner buttons. To enable the undo feature for all operations involving data lists created from an external data model (regardless of how long the undo operation takes), simply deselect the Disable Undo for Large Data Model Operations check box.