Thursday 25 November 2010

Excel 2007 Advanced Filter Runs Very Slowly

Title:
Excel 2007 Advanced Filter Runs Very Slowly


Video:


Description:www.contextures.com An Excel Advanced Filter is a speedy way to extract data from a table, or filter a list by several criteria. However, you might run into a problem in Excel 2007, when an advanced filter runs very slowly. It almost looks like Excel is copying and pasting each row of data separately, and you can imagine how long that would take! In a file where this problem occurs, this Excel video tutorial shows how to solve the problem, by removing worksheet comments. Fortunately, this problem appears to be fixed in Excel 2010.

Published:
26/Nov/2010

No comments:

Post a Comment