Excel 2007 Tables

Excel 2007 tables by default create a named range. Further, new records entered directly under the table cause the table and its related named range to automatically expand to include the new data. Thus, any formulas or pivot tables or charts that are based on the table's name will automatically include the newly inserted data.  This is a wonderful feature of Excel 2007 tables!