While working on a spreadsheet with Office XP, I enabled the autofilter feature but I noticed that when sorting, it would only sort column A-AK only. If I try to sort on one of the remaining column (AL-AS) only them will be sorted, it's as if Excel considered those 2 bundles completely different dataset. I heard about limitations on the number of records and displayable values in the drop-down list, but I'm far from those figures (only got about 200 rows).

Anyone has any clue on why this is happenning and possibly a solution to this (yes I can do VBA if necessary :P ).

Thank you all.