Unlike Access, Excel does not have an auto-numbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own auto-numbering to a data list.
To keep track of their changes, insertions, and deletions, you need to designate the workbook as a shared workbook before distribution.