Filter & Sort
 

I have an excel document with an autofilter turned on in the row above my
data. I'm running Office 2007 but always save my docs in 97-2003 compatible
format because 1/2 our staff has not yet been migrated to the 07 version.
When I try to sort my columns in ascending or descending order, it works
perfectly. However, when the folks on backlevel versions of Excel perform the
same sorts, they end up with the first entry in the column not being included
in the sort - the rest of the column sorts properly. Any ideas?

Filter & Sort
 

On older versions, instead of using the sort from the Autofiklter
dropdown.........

Go through DataSortMy data range has "no header row"

Checkmark it.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 09:10:16 -0700, Karin
wrote:

I have an excel document with an autofilter turned on in the row above my
data. I'm running Office 2007 but always save my docs in 97-2003 compatible
format because 1/2 our staff has not yet been migrated to the 07 version.
When I try to sort my columns in ascending or descending order, it works
perfectly. However, when the folks on backlevel versions of Excel perform the
same sorts, they end up with the first entry in the column not being included
in the sort - the rest of the column sorts properly. Any ideas?

Filter & Sort
 

It's already set to 'no header row'. Here's a little more detail. Older
version is 2003. Data looks similar to:
COLHDRTEXT
blank row with filter
1
504
78
360

If I choose through the autofilter to sort in descending order I get
1
504
360
78

"Gord Dibben" wrote:

On older versions, instead of using the sort from the Autofiklter
dropdown.........

Go through DataSortMy data range has "no header row"

Checkmark it.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 09:10:16 -0700, Karin
wrote:

I have an excel document with an autofilter turned on in the row above my
data. I'm running Office 2007 but always save my docs in 97-2003 compatible
format because 1/2 our staff has not yet been migrated to the 07 version.
When I try to sort my columns in ascending or descending order, it works
perfectly. However, when the folks on backlevel versions of Excel perform the
same sorts, they end up with the first entry in the column not being included
in the sort - the rest of the column sorts properly. Any ideas?

Filter & Sort
 

That's what I said...........if you use the AF sort Excel always assumes the
filter arrow row is a header so leaves it out of the sort.

With the DataSort method you can change this to "no header"


Gord

On Thu, 11 Sep 2008 11:26:01 -0700, Karin
wrote:

It's already set to 'no header row'. Here's a little more detail. Older
version is 2003. Data looks similar to:
COLHDRTEXT
blank row with filter
1
504
78
360

If I choose through the autofilter to sort in descending order I get
1
504
360
78

"Gord Dibben" wrote:

On older versions, instead of using the sort from the Autofiklter
dropdown.........

Go through DataSortMy data range has "no header row"

Checkmark it.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 09:10:16 -0700, Karin
wrote:

I have an excel document with an autofilter turned on in the row above my
data. I'm running Office 2007 but always save my docs in 97-2003 compatible
format because 1/2 our staff has not yet been migrated to the 07 version.
When I try to sort my columns in ascending or descending order, it works
perfectly. However, when the folks on backlevel versions of Excel perform the
same sorts, they end up with the first entry in the column not being included
in the sort - the rest of the column sorts properly. Any ideas?