Microsoft KB Archive/24155

{| = Excel: Appending Records to a Defined Database =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q24155

SUMMARY
Every time a record is added to the end of a Microsoft Excel database, the database must be redefined to include the new information in database calculations.

To add records to the end of a database without redefining the database each time, do the following:


 * 1) When first defining the database, include a blank record at the bottom of the database.
 * 2) When adding records to the end of the database, select the last record and choose Insert from the Edit menu.

The database range will now include the new information without having to be redefined.
 * }