Remove subtotals and turn off outlining before you apply Remove Duplicates. If you're new to Microsoft Excel 2007, take time to study the Remove Duplicates feature, as it did not appear in Excel 2003.

The 2007 versions of Word, Excel, PowerPoint, and Publisher list an option to remove personal information from file properties on save (this may be grayed out), as well as a Document Inspector ...