General
Ignore other applications that use Dynamic Data Exchange (DDE) - Prevents the exchange of data with other applications that use Dynamic Data Exchange (DDE).
Ask to update automatic links - Displays a message that lets you confirm before any external links are updated. more
Show add-in user interface errors - Displays errors in the user-interface of add-ins that you install and use. The default is not ticked.
Scale content for A4 or 8.5 x 11" paper sizes - For some countries or regions, the standard paper size is Letter; for others, the standard size is A4. Select this check box if you want Excel to automatically adjust documents formatted for the standard paper size of another country or region (for example, A4) so that they print correctly on the standard paper size for your country or region (for example, Letter). This option affects the printout only. It does not affect the formatting in your document.
Always open encrypted files in this app - (Added in 365).
At startup, open all files in - At startup, Excel automatically opens files from the folder that you type in this text box. Type the full path to the folder in the text box to indicate the location of the files. Unfortunately there is no folder browse button so you have to copy and paste the folder path.
Web Options - Sets options for how Excel data looks and responds when the data is viewed in a Web browser.
Enable multi-threaded processing - This controls all multi-threaded operations (except calculation). This includes sorting, row height calculations and finding the best fit for column widths. This option is not available in the object model. Selected by default but you need to have a multi-threaded processor. The default is ticked.
Create lists for use in sorts and fill sequences - Displays the Custom Lists dialog box.
Disable undo for large PivotTable refresh operations to reduce refresh time - (Moved in 2013). This has moved to a new dedicated Data tab above.
Disable undo for PivotTables with at least this number of data source rows (in thousands) - (Moved in 2013). This has moved to a new dedicated Data tab above.
Provide feedback with sound - (Moved in 2019). This has been moved to the Accessibility tab.
Provide feedback with animation - (Moved in 2019). This has been moved to the Accessibility tab.
Service Options - (Removed in 2013). Lets you specify customer feedback and document management options.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext