PDA

View Full Version : Excel Auto-filter



09-05-1999, 06:08 PM
I use Office 97 on an HP Pentium 166 with 24meg Ram. One .xls file I have built up is 800k with around 1000 records. I frequently use the autofilter function to select records which meet certain criteria. After several 'what-ifs', the message 'Calculating 100%' appears on the bottom line. The keyboard locks up. With the keyboard and cursor frozen, I have to turn off the machine and reboot. Any ideas?