We’re seeing an issue in Excel 2007 related to sorting data using the sort within an auto filter. Excel behaves differently if you run the sort from the filter drop-down or if you run it from the Ribbon. From the Ribbon, the sort function works every time for all columns. From the drop-down, Excel only sorts the filtered columns.
This behavior is different than 2003 where Excel sorts all of the columns regardless of how many columns have filters. This is a problem since there are manyspreadsheets created in earlier versions of Excel with filters on only some columns and there is no warning that the data will become inconsistent. Any assistance is greatly appreciated.
Below are the steps to recreate the problem.
1. Create a blank spreadsheet in Excel 2007.
2. Populate the first row with column headers.
3. Populate a few rows worth of data.
4. Select some, but not all, columns and click the Filter button on the Ribbon. This applies filters to the columns you select, not all columns.
5. Use the sort feature in the drop-down menu in the column header to sort the data.
6. No warning is given. Only filtered rows sort. Your table now has inconsistent data