Updates

2016	new hammer icon at the top of the slicer
2007	The 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) - https://docs.microsoft.com/en-us/previous-versions/office/developer/officetalk2007/bb693324(v=office.11)
Bringing Improvements to Tables in Excel 2007 (Part 2 of 6) - https://docs.microsoft.com/en-us/previous-versions/office/developer/officetalk2007/bb736198(v=office.11)
Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists - https://docs.microsoft.com/en-us/previous-versions/office/developer/officetalk2007/bb462636(v=office.11)