I am using Excel 2007 and have a spreasheet with 400,000 rows. When I try to do vlookups and/or filters, it's taking about 20 minutes or so to complete each command. The file size is over 100 MB. How can I speed it up? Is this even possible?
I am working on an HP Pavilion dm4 laptop with...