Microsoft Office Development and Consultancy

Excel

2010 Changes

2007 Changes

New dialog box to replace the old (Tools > Options) dialog box - resizable and consolidated

Include a summary of the different tabs

(Popular tab, Color Scheme) - blue, silver, black option

(Popular tab, Username) - has it changed / different - case changed ??

(Advanced tab, Editing Options, Alert the user when a potentially ..

(Advanced tab, Editing Options, when this number of cells ???

(Advanced tab, Editing Options, Group dates in the Autofilter

(Advanced tab, Formulas, Enable multi-threaded number of calculation manual)

(Advanced tab, Display options for this workbook)

The chart tab in 2003 has been moved. The hidden and empty cell options can now be accessed from the Select data Series dialog box.

ALTERNATIVE STARTUP DIRECTORY

This has been been renamed to ???

If allow trusted on my network = false then you will get the old dialog box when the workbooks are opened

If allow trusted on my network = true then you won't get a prompt when the workbooks are opened

If allow trusted on my network = false the location will not appear under the policy locations

If allow trusted on my network = true the location will appear under the policy locations.

(Advanced tab, Editing Options, cursor movement)

(Advanced tab, Editing Options, logical)

(Advanced tab, Editing Options, visual)

Image size and quality - discard editing data

do not compress images

set default taregt