Excel 2007 Workbook Performance Issue When Using Filter

[tvandersluis]

Why would I be experiencing performance issues when using a filter in my excel 2007 workbook. The workbook is 113,110 KB, has many sheets, many pivot tables (using same data source for most), lookup formulas, charts with autopopulate based on lookups. When I insert a filter in one of my data sheets, it processes very slowly, like 1-2% at a time. Is there anything I can do to help the performance of this workbook without having to install more RAM on my PC?

 

[Datsmart]

You might try turning Calculation off at the begining of your code, them turn it back on at the end.

    EnableCalculation = False 'Turn off Calculation
' Your Filter code here....
    EnableCalculation = True 'Turn on Calculation