Updates

2016new hammer icon at the top of the slicer
2007The term "List" was introduced in Excel 2003 to provide a way of updating and editing lists saved to a SharePoint site. This term has been changed in Excel 2007 to "Table" to make it more consistent with Word and PowerPoint.
 New interface to quickly create, format and expand tables
 Table header rows can be turned on or off
 Column headings remain in view when you scroll
 Calculated columns using formulas that automatically expand to additional rows
 Automatic auto filtering turned on by default
 Structured references
 Total rows
 Custom formulas and text entries to the total row
 Auto expansion, expands the table automatically when you type new rows below (or columns right ?)
 INSERT ROW
 In Excel 2003 there was a special row at the bottom of a list to allow you to add a new row.
 In 2007 this has been removed and extra rows can be inserted by using the Tab or Enter keys or by dragging the resize handle
 If code uses the following:
 ListObject.InsertRowRange then it might need to be changed.
 TABLE STYLES
 The have replaced the old auto format dialog box
 SORTING
 You can now sort more than 3 columns (up to 64 levels)
 Sort data by colour
 Sort data using custom lists
 FILTERING
 In Excel 2003 you could check the AutoFilterMode property to determine if a list has autofiltering turned on or not. In Excel 2007 this will only work with worksheet autofilters and not with autofilters that are connected to tables. In Excel 2007 each table has its own AutoFilter object which enables multiple autofilters per worksheet through the user of tables. To correct this problem enable the AutoFilter task off the List object, instead of at the macro level.
 Drop-down list can display more than 1000 items.
 Quick on/off toggle rather than having to select (Data > Filter > AutoFilter) to toggle.
 Filtering on several items is not possible.
 Date filtering improvements - choice of months/days
 MULTIPLE FILTERS
 Annoying extra clicks
 CALCULATED COLUMNS
 REMOVE DUPLICATES DIALOG BOX
 This can be displayed from (Data tab, Data Tools)(Remove Duplicates)
 The "new row" that was displayed at the bottom of a list has been removed. In Excel 2007 just typing below the table will trigger a new record. Alternatively you can use (Table > Insert Row)
 Creating a table in Excel 2007 will also define a named range for that table which can be used for easy referencing in formulas and functions.
 In Excel 2003 you could read and write lists that resided on a SharePoint site. In Excel 2007 the ability to write changes back to a SharePoint site has been removed. Lists created in Excel 2003 will continue to have the write capability. Any new tables that are connected to a SharePoint site will not support the ability to write back.
 It is still possible to publish a table to a SharePoint site by using a "one time" write option. After publishing the table any links to the list are "Read-only". Any read write connections to a SharePoint site are converted to read only when a workbook is saved in the new XML file format. Because the table is read-only the table can be easily manipulated and modified in Excel without the changes being saved to SharePoint.
 New Search box with live preview
 Table column headings stay at the top giving you immediate access to sorting and filtering without having to scroll to the top of the table.
 Number of items shown in the AutoFilter drop-down increased from 1,000 to 10,000
 Sort and Filter by background cell colour
 Filter by applying "Quick Filter" for specific data types (month quarter etc)
 Reapply a set of filters with one click
 Sorting up to 64 levels
 Inline "drill indicators" ??


- Bringing Improvements to Tables in Excel 2007 (Part 1 of 6)
- Bringing Improvements to Tables in Excel 2007 (Part 2 of 6)
- Bringing Improvements to Tables in Excel 2007 (Part 3 of 6)
- Bringing Improvements to Tables in Excel 2007 (Part 4 of 6)
- Bringing Improvements to Tables in Excel 2007 (Part 5 of 6)
- Bringing Improvements to Tables in Excel 2007 (Part 6 of 6)
- Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext