I've got a file with data in about 4,000 rows and about 45 columns, however, not totally populated. When I apply AutoFilter it slows down Excel considerably. Is there any way to speed it up? It is hardly possible to work with data. I tried to break the file in three, but 2000 rows seem too much as well.
I've got WinXP and Office XP on Athlon Thunderbird 1 GHz and 256 MB RAM. (the spec in my profile is for work not home)