Forum Home
Press F1
 
Thread ID: 1450 1999-05-09 06:08:00 Excel Auto-filter Guest (0) Press F1
Post ID Timestamp Content User
1802 1999-05-09 06:08:00 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? Guest (0)
1