How to Improve Response Times for Large Datasets.

In the case of the worksheet the speed of update will dramatically improve if fewer columns are included i.e. the performance of the worksheet and the filter control are a function of the number of cells that are included in each

In the case of the filter control, using a property such as Employee ID or Full Name will have a very significant impact on performance.